Private Sub Combo2_Click()
If Combo2 = "No" Then
Text0.Visible = True
Text0.Enabled = True
Else
Text0.Visible = False
Text0.Enabled = False
End If
End Sub
Also place this code or call it in the Form's Current event (I prefer to code it in the Current event and just put Call Form_Current in the Click event, but that's me).