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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

required textbox entry 2
vba macro that allows insertion of symbols at cursor 0
Access Dateadd function question.. 0
Help with Data Entry Form 1
data entry 3
TRY TO MAKE TEXTBOX AS REQUIRED FIELD 2
form to subform 1
Problem with Validation Error 10

Back
Top