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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try this as validation rule --
Like "*" & "@" & "*" & "." & "???*"

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

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

to ensure there's something before and after the @?
 
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
 
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
 
Back
Top