Forced "@" in Field

D

Darren

Is there a way to ensure that in a field for e-mail addresses, the "@" sign
must be present somewhere in the address?
 
A

Allen Browne

Open your table in design view.
Select your email address field.
In the lower pane of table design, set the Validation Rule to:
Is Null Or Like "*@*"

For a more comprehensive rule, consider something like this:
Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))
 
Top