Hide Show Text Box

[Derrick T. Davidson]

I think this an easy one for you experts I Have a Txt Box [Box1] if this txt box shows "Yes" then I want to show [Box2] if it shows "No" I want to hide [Box2}

[Derrick T. Davidson]

FYI I entered the following code in Box2 Private Sub Box1_Enter()
If Box1= "Yes" Then
Box2.Visible = True
Else
Box2.Visible = False
End If
End Sub

[Bob Fitz]

Try:

If Me.Box1= "Yes" Then
  Me.Box2.Visible = True
Else
  Me.Box2.Visible = False
End If

Needs to be in the After Update event of Box1. You may need it in the On Current event of the form too.

[Derrick T. Davidson]

Perfect Thank you Bob