Show/hide fields on a form.

djt2009

New member
Local time
Today, 21:55
Joined
Oct 21, 2009
Messages
5
Hello all.
Is it possible to show and hide certain fields on a form, based on whether a check box is ticked or not?
 
Try via "Visible" property.
Me.[Field Name].Visible = True
or
Me.[Field Name].Visible = False
 
If you want to show a field when the check box is checked and hide it when it is unchecked, try;
Code:
Me.YourFieldName.Visible = Me.CheckBoxName

As the Check box will return a True (checked) or False (unchecked) result you can use it directly to show or hide the field via it's Visible property.
 

Users who are viewing this thread

Back
Top Bottom