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.)
 
Top