field visibility in MSAccess Form

[gimpie1941]

I need to change the visibility of a field in a Form Detail section based on the value of another field in the same record. Therefore, some records will display all fields, while some will only display a few fields, based upon the value of one field.
The problem I have is that if one record displays all fields, then all records will display all fields even though some records should not (based on value in select field).
Can anyone help?
Gimpie

 

[dhookom]

I assume your form is in either continuous or datasheet view. If so, you will need to use conditional formatting. This assumes you are running Access 2000 or greater.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[gimpie1941]

Thanks dhookom,
Yes it is continuous forms. I display 5 fields per record which are yes/no boxes (disciplines B,E,F,M,P). I use these to change status of each field on each record. However, not all records utilize all five fields (second field not displayed is an 'active' field, one for each discipline to show whether it is needed for this record. The user then changes statuses on only those disciplines that are active for the specific record. Since some records utilize all five disciplines and some only use one or two, I need the ability to only display those 'active' on each record. Then the user will only set the status (Yes or No) for the appropriate fields.
I will look into conditional formatting.
THanks, Gimpie

 

[dhookom]

gimpie1941,
You primary issue is using Access like a spreadsheet. I would normalize your tables so that you didn't have repeating columns. Each discipline should create its own record rather than its own field.

What do you do if you need to add another discipline? This should create another record in a lookup table of disciplines. You should never have to add fields and/or controls.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.