Tab control

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

Guest

I need the user to enter data in each field - in order. Can I prevent the
user tabbing onto another field if a mandatiory field is left Null ?
 
Glynn,
Use the OnExit event of the field, which has a Cancel capability...

If IsNull(YourFieldName) Then
Beep
MsgBox "Requires an Entry"
Cancel = True
End If

Also, make sure the field is designated "Required" in your table design, so users can't
leave the record without an entry even if they didn't tab into the field.
 

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

Back
Top