Hide/reveal controls

[Mark Sippitt]

Hello Anna,

OK. If you have a Text Box called Text1 on your Form and
a Command Button Command1.

On the OnClick Event of your Command Button you could have
the following code:

Me!Text1.Visible = True

And continue for all the controls you want to show / hide
etc

Hope this helps.
Mark

 

[Anna]

Hi Mark,

That's great, thanks - is it possible to make the fields
hidden by default every time I enter a new record? This
doesn't seem to be happening at the moment.

Thanks for your help,

Anna

 

[Mark Sippitt]

Hi Anna,

Initially you can set the Visible property to False on all
the fields you want to hide. Then when a Command Button
is clicked then the fields can be displayed using the code
below.

Feel free to shout if you require furtehr clarification
Mark