Validating Email Address

  • Thread starter Thread starter Bill Johnson
  • Start date Start date
B

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?
 
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 "*[ ,;]*"))
 
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?
Click to expand...


.
Click to expand...
 
Back
Top