VBA to hide / show LABEL or TEXT box

D

Dirk Goldgar

Martin said:
VBA to hide / show LABEL or TEXT box ? How?
Click to expand...

Set its Visible property. For example,

' code running on the form containing the object:
Me!NameOfControl.Visible = False ' hide it
Me!NameOfControl.Visible = True ' show it again

' code running somewhere else:
Forms![NameOfForm]!NameOfControl.Visible = False
Forms![NameOfForm]!NameOfControl.Visible = True

If a label is attached to text box, hiding the text box will also hide
the label.
 
M

Martin

Thanks!

Dirk Goldgar said:
Martin said:
VBA to hide / show LABEL or TEXT box ? How?
Click to expand...

Set its Visible property. For example,

' code running on the form containing the object:
Me!NameOfControl.Visible = False ' hide it
Me!NameOfControl.Visible = True ' show it again

' code running somewhere else:
Forms![NameOfForm]!NameOfControl.Visible = False
Forms![NameOfForm]!NameOfControl.Visible = True

If a label is attached to text box, hiding the text box will also hide
the label.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Top