Conditional Formatting should have Visible/Invisible option.

[John D Smith]

In Access, I'd like to be able hide fields which are not relevant to the
current record, as is possible in CSS in internet applications. For example,
in a form I have a Yes/No field. The next 4 fields are pertinent based only
on a Yes response. While I can 'disable' the controls via Conditional
Formatting, I'd like to hide them altogether.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...ca1&dg=microsoft.public.access.tablesdbdesign

 

[Tim Ferguson]

In Access, I'd like to be able hide fields which are not relevant to
the current record, as is possible in CSS in internet applications.
For example, in a form I have a Yes/No field. The next 4 fields are
pertinent based only on a Yes response. While I can 'disable' the
controls via Conditional Formatting, I'd like to hide them altogether.

(a) -- you can hide them: use the Form OnCurrent event and the AfterUpdate
event of the check box control to manipulate the Visible property of the
text box controls;

(b) -- to my mind, this question is pathognomonic of a design problem. The
missing fields should be dependent on the primary key, not on the PK plus
some other boolean field.

HTH


Tim F