About using input masks for email addresses
Microsoft Access
Because email addresses vary widely in the number of characters they contain, input masks are not a good tool for ensuring that email addresses are entered correctly. Instead, we recommend using the Validation Rule and Validation Text properties.
The validation rule shown in the following table ensures that the email address is entered with one or more characters, then an “@” sign, then one or more characters, then a period, and then one or more characters. For example, tom@example.com would be allowed, but tom@example,com or tom@example would not. If you enter an email address that doesn’t match the validation rule, Access doesn’t accept the input and displays the message in the Validation Text property. If no text is entered in the Validation Text property box, Access displays a generic message.
|
Property |
Setting |
|
Validation Rule |
Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*")) |
|
Validation Text (optional) |
Please enter the email address with an '@' sign and the full domain name (for example, 'frank@contoso.com'). |
For more information about using validation rules, as well as step-by-step procedures, see the article Restrict data input by using a validation rule.