Validate field format in code

[hpl2001]

Hello:

I have an access database, with a form field that has the following input mask: !0000\-00000;0;_

When a user eneters a value that does not match I get an error message the requests the above described input format (confusing to user). I would like to capture any error so that I can display a message to show that the format should be 0000-00000. I want to use VBA to test if the current value for the field follows this input mask, but I'm not clear on how to code that. Any thoughts?

 

[PHV]

Use the Error event procedure of the Form.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kjv1611]

Here's one nice reference (I'm sure you can find many others) with lots of detail on using the Error Handler in Access databases:

http://allenbrowne.com/ser-23b.html

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57