When a field gets the focus, if the field value is null, I'd like to set the field visible to false, and refresh the form with this field not being displayed. The field name is "Type." This is the code I have entered in the On Got Focus Event:
If Me.TYPE.Value = Null Then
Me.TYPE.Visible = False
Me.Repaint
End If
I've tried both refresh and repaint, and neither works for me.
Is what I'm trying to do possible? Thanks in advance