Validatine field for "@" and "." in email address

L

Laser

I know it is not possible to input mask code for email but I want to at least
verify there is an "@" and "." in the field like we do on web forms using
javascript.

Can someone help me with coding as I've never done it in Access.

Ideally, it would be nice to verify there is text before "@", between "@"
and "." and possibly a valid domain extension after the "."

Thanks
 
K

KARL DEWEY

Try this as validation rule --
Like "*" & "@" & "*" & "." & "???*"

The three question marks says that there must be at least three characters
after the period.
 
D

Douglas J. Steele

What about

Like "*?@?*.???*"

to ensure there's something before and after the @?
 
L

Laser

Thanks very much. MVP Steele's addition makes sense. - I'll try it Monday
when we get back to work. Have a nice weekend.

Laser
 
L

Laser

Passing along Unposted tip from another reader:

use only 2 ? in extension because ".us" is common now as well as many
foreign 2 character domains.

Like "*?@?*.??*"


Laser
 
Top