Multiple fields set to visible or invisible based on field content
If I had say 10 fields all all those 10 fields were to be set to invisible or visible depending on a single check mark box, could I say 'draw' something maybe a special 'frame' around those10 fields so that I can refer to the 'frame' and everything in that area could be invisible or visible based upon the check mark box versus having to code 10 fields individually?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
On a continuous subform, I have a set of fields (all at the bottom of the Detail section) that normally I want to be invisible. On the click of a button, I want to set all their Visible properties to True.
So when the fields are invisible, I'd like to set the height of the Detail section to exclude the "real estate" reserved for the invisible fields, and then, on the click of the button,reset the height at the same time that I set the visibility properties.
and the code is :
If Me.Field1 = 1 then
Me.Field2.Visible = False
But the problem is that when I type Me.Field2.
the word Visible doesn't appear on the list
The data set of the form is actually a query that contains all the fields required for the export.
If I place all the fields on the (continuous) form but make the ones the user doesn't need to see invisible they are not exported using the standard external data->export/Excel. I can think of a couple of ways round this like making all the fields visible but transparent/white font etc or placing a button on the form and generating the export by dynamically creatinga query based on any filtering the user may have chosen.
However, I was wondering if there is a tidier way to achieve the export of the required fields?
In my example, I have two check boxes which I have set up to allow only one choice. So when you check one, the other becomes unchecked!
Behind both these check boxes I have managed to write the code which does make the command button visible/invisible depending on which check box is checked. See bellow
However, the crucial bit I am missing is that it does the same response for ever record. So if I want it invisible in one record that's fine,but then if you go to the next record where you want it to be visible, and have checked the correct box for this to happen, it is still invisible. What I need is some additional coding which ties it to the current record?
I have a report called rptDrillDown which gives the details of a record after being called by an On Click event from the summary report. So far, It's calling up just fine. However, each record has a check box indicating whether the study has to be implemented.
When the box is checked, a whole bunch of fields show up with dates to track the implementation. When the boxis unchecked, the fields are invisible.
This works great on my data entry form, but not so much for my report. not so much.
I have an inventory form that lists the cost and retail price of an item When I select the "Location" of the item (where it is being sold, ie: Betty's Bargain Barn) I want a heading that says Consignment to appear as well as the Price.
There are other locations that can make this consignment heading and price field appear, so it would need to have more than one "IF" in it. I tried to create the code but it won't show up.
Based on the selection in the Option Group, I want some fields visible and others not. Somefields need to be visible all the time, others only visible part of the time.
Basically, if option 1 is selected, I want fields A, B, C, D, H, I, L, O, and Z visible. If option 2 is selected, I want fields A, B, C, E, F, P, and Y visible. If option 3 is selected.
I have all fields visible all the time and merely fill in the fields needed for the selected option. This method is no problem for me, butmy co-workers have seen me working on this project and would also like to use the data base, so I have to make it a little more use friendly so the appropriate data is entered.
The problem I have is that it only returns a record based on 1 field.
Is there a way for me to use both the ID field and Name field in my report design but make it so that only the name field is visible in the Preview and reportoutput?