Topics Search

Multiple fields set to visible or invisible based on field content

Multiple fields set to visible or invisible based on field content
Views: 101
I got lots and lots of fields need to be set to visible or invisible based on field content. Manually coding of this is possible it just takes forever. This is what I am wondering (ifthis is possible or exists or not):

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?
Sponsored Links:

Similar posts...

 

How to change the height of the 'detail' part of a form?

How to change the height of the 'detail' part of a form? Icon
I know how to set this Property, but what I'm really asking is how I can set it to something smaller than it wants to be.

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.
 

Invisible field on a report

Invisible field on a report Icon
In a report on a certain condition I want the field to be invisible
and the code is :
If Me.Field1 = 1 then
Me.Field2.Visible = False
End if
But the problem is that when I type Me.Field2.
the word Visible doesn't appear on the list
 

Exporting invisible fields on a form to Excel

Exporting invisible fields on a form to Excel Icon
I'm using Access 2010 and I have a form that will be used to select or filter records which will then be exported to Excel. However, I only want to show the critical fields that will be used to make the decision on which records to export on the form but export a far larger set of fields.

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?
 

Making a Command Buttong Visible/Invisible

Making a Command Buttong Visible/Invisible Icon
I am working on a database in which I am trying to write some code which displays a command button dependant on another action.

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

[CODE]

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?
 

Hide Part of Report Based on Field Value

Hide Part of Report Based on Field Value Icon
Visible status of an object in a Report based on the value of one of the fields in the 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.
 

Make a field visible based on the combo box selection

Make a field visible based on the combo box selection Icon
I am using MS Access 2010. I have a field that is invisible. I want to make it visible based on the selection from a combo box. There are more than one possible selections that would make this visible. Here is the breakdown.

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.
 

Make Access Report Column Visible/Invisible based on Condition

Make Access Report Column Visible/Invisible based on Condition Icon
Wondering if there's a way to make an access report column visible or invisible based on a condition?
 

Make fields visible with selection in Option Group

Make fields visible with selection in Option Group Icon
I have a form with a sub-form. It has a one to many relationship based on a case #. In the sub-form I have an Option Group with 7 options that distinguish the item type. Depending the the item type I need other information that is gathered in other fields in the sub-form.

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.
 

search on multiple fields

search on multiple fields Icon
I need a little advice/guidance with searching for a record based on multiple fields. Basically I have a list box which I've set up to 'Find a record on my form based on a value I selected in my list box'

The problem I have is that it only returns a record based on 1 field.
 

Can Group Header Be Made Invisible?

Can Group Header Be Made Invisible? Icon
I am designing a report which includes both a CommitteeGroupID field and a CommitteeGroupName field. I am grouping by the ID field but the end users don't care about that field and only want to see the Name 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?