required entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

kinda of stupid question but my brain is on vacation. wondering how to make
it so on a non bounded textbox, a user is required to enter a value and is
not allowed to leave the textbox without doing so?
 
Try putting this code in the On Unload property of the form:

If IsNull(Me!MyTextbox) Then
MsgBox "Must enter a value in the text box."
Cancel = True
Me!MyTextbox.SetFocus
End If
 
Back
Top