Hiding fields

[BIGGY]

On a form, what is the best way to hide a label or text box? I'm guessing that I can do a checkbox which would work for me and just write a macro to hide on a false value?

 

[jrjr]

You can use a check box if that is what you want, or any one of a zillion different ways. Set the visible property of your label or text box to no first. Substitute your names.

Private Sub CheckBox_AfterUpdate()

If Me.CheckBox = yes Then
Me.TextBox.Visible = True
Else: Me.TextBox.Visible = False
End If
Me.Refresh

End Sub