Table Design Field: EMail Address Format/Mask

J

JG316

Is there a mask I can set to make sure the email address
corresponds to the proper format?
 
A

Allen Browne

Try a validation rule of:
Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

That specifies:
- at least one character;
- the @ sign;
- at least one character;
- the dot;
- at least one character;
- no space, comma, semicolon (or whatever other characters you wish to add
to the exclude list.)
 

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

Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
How do I code an e-mail address in an controls input mask? 1
Changing login email address for office 365 admin (O365 Busines) 0
Input Mask - 'Evil' and 'Not Useful' 15
Have 4 email addresses Want to auto forward all in one of them 0
Address Format changed after Migration 0
Outlook - Catgorizing emails by names 0
Setting time input mask 4

Top