Hiding Controls

[Michael]

I have a simple Data Access Page that runs from a simple query. I need to
find a way to hide a few controls (Text Boxes).
The control that will decide the faith of the textboxes is a Checkbox, the
field in the source table for this checkbox is a Yes/No field, I want the
text boxes to be hidden when the Check box is not checked as well as the
check box otherwise everything should be visible.

 

[Ryan]

In the forms "On Load" event you would add this code.
If ([Me!CheckboxName] = False, Me!CheckboxName.visible = False,
Me!Checkbox.visible = True)

 

[Ryan]

Actually, you should use the forms "On Current" event to add the code.