G Guest Sep 3, 2005 #1 Is there a way to ensure that in a field for e-mail addresses, the "@" sign must be present somewhere in the address?
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 Sep 3, 2005 #2 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 "*[ ,;]*"))
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 "*[ ,;]*"))
A Al Camp Sep 3, 2005 #3 Darren, Check out the InStr function. - hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions
Darren, Check out the InStr function. - hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions
