Table Design Field: EMail Address Format/Mask

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"JG316" wrote in message
...
Is there a mask I can set to make sure the email address
corresponds to the proper format?