Hide Control on Form Given Condition

L

lhcpr

Hi all,

A quick question.

I need help hiding a control (check box) on a data entry form. What
need to do is have the check box control hidden whilst a nearby tex
box remains empty. When text is entered into the text box, I need th
check box control to be displayed.

Any suggestions would be great. Please keep in mind that my experinc
is limited.

Cheers,

lhcp
 
O

Ofer

On the After update event of the Text field write

Me.[CheckBoxName].Visible = Not (IsNull(Me.[TextBoxName]) Or
Me.[TextBoxName] = "")

Also, if you navigate between the records in the form, add this code to the
OnCurrent event of the form.
 
Top