Hide Controls in Datasheet.

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Hi;

Have a Sub-Form that contains some controls that should be hidden unless
they are needed.
There are three check boxes that will display those controls using "If =
True then Control = Visible" for example.

The obstacle is that the Sub-Form is displayed only in datasheet view.

Set the controls properties to Visible=No. That doesn't work. The controls
remain visible.

Set the "Open form" event to: Me![ControlName].Visible = False.
That doesn't work. The controls remain visible.

In Form view they are invisible, but this application needs the sub-form to
display only in Datasheet view.

Any suggestions?

Andy
 
Have a Sub-Form that contains some controls that should be hidden unless
they are needed.
There are three check boxes that will display those controls using "If =
True then Control = Visible" for example.

The obstacle is that the Sub-Form is displayed only in datasheet view.
Click to expand...

Then I really think you're out of luck. Datasheets are quite
inflexible.

Consider using a Continuous Form (which can be made to look very like
a datasheet). Even here, however, there is really only ONE control,
displayed many times; you cannot independently toggle the visibility
of controls in separate records.
 
Back
Top