INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I have to add my thanks and appreciation for your wonderful site... People who frequent the site are the two best things - nice and smart..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Languages > VBA Visual Basic for Applications (Microsoft) Forum

Validate format in VBA

Read More Threads Like This One

hpl2001 (Programmer)

20 Jun 12 9:49

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?

SkipVought (Programmer)

20 Jun 12 9:55

forum702: Microsoft: Access Forms for better results in MS Access.

Skip,
_{Just traded in my old subtlety...

for a NUANCE!}