Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

overriding input mask failure message

Status
Not open for further replies.

ytakbob

Programmer
Jul 20, 2000
105
US
When a user does not adhere to my input mask, access throws up a msgbox with a cryptic message indicating failure.

What event or method can I use to "override" this message and use my own?

Thanks Bob Schmid
bob_schmid@hmis.org
330-746-1010 ext. 1347
 
What input mask are you using?

The simplest way around this is to create a validation rule that would catch any errors, and have your validation text be whatever you wanted to pop up. Both of these properties are in the text box's properties list under data, if you want to play around with them.

HTH!

-Brad
 
Assuming that you're using a form, you can try the OnError event. I don't know if it would work with that error, however. Either way, blarson0's suggestion is a good one if you can do it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top