Validating Email Address

[Bill Johnson]

I've seen in some websites where you enter your email
address, it validates that the address you've entered is
in a proper format : (e-mail address removed) or (in my case)
(e-mail address removed)

How is that done? is there a simple way I can use
validation to get that result?

 

[Allen Browne]

For a basic check you could put this into the Validation Rule of your email
field (lower pane in table design view):

Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

 

[Bill Johnson]

Thank you!

I'll give this a try.

-----Original Message-----
For a basic check you could put this into the Validation Rule of your email
field (lower pane in table design view):

Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;] *"))

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I've seen in some websites where you enter your email
address, it validates that the address you've entered is
in a proper format : (e-mail address removed) or (in my case)
(e-mail address removed)

How is that done? is there a simple way I can use
validation to get that result?

.