By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

emailladdress validation rule

P: n/a
Hi All

I was wondering how a emailaddress validation rule looks like. I was
hoping that either a wizard that offers example fileds or the example
database that comes with access would provide that.

Thanks.

Toby
May 1 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
If you want your software to validate that the domain name is valid, this
gets messy and you would need a connection to a domain name server.

If you just want to ensure that the email address follows the basic format,
you could try putting this Validation Rule on the field in your table:
Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

The rule permits no email address (null.)
If there is an entry, it must be at least one character before the @, then
at least one more character before the dot, and then at least one character
after the dot. Additionally, any characters you place in square brackets are
not allowe in any position, so the 3 illegal characters in the example are
space, comma, and semicolon.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<to*****@hotpop.com> wrote in message news:e3**********@news.Stanford.EDU...
Hi All

I was wondering how a emailaddress validation rule looks like. I was
hoping that either a wizard that offers example fileds or the example
database that comes with access would provide that.

Thanks.

Toby

May 2 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.