Hide Controls in Datasheet.

[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

 

[John Vinson]

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.

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.

 

[Andy]

John;

You answered my question; gave me an insight and an inspiration..

Thank YOU.

Andy