Table Design Field: EMail Address Format/Mask

  • Thread starter Thread starter JG316
  • Start date Start date
J

JG316

Is there a mask I can set to make sure the email address
corresponds to the proper format?
 
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.)
 
Back
Top