Originally Posted by LiBOC

Hi,

I am using MS ACCESS. I want to validate a particular field.
To check whether if its a valid email address with a @

So anyone have tutorials or website to reccomend or even reply off hand with the expression to check for @ in a string?

Thanks alot.

Originally Posted by PCsrivastava

Yes
You Can Validate A Field Which Must Contain "@"
for That Open Table In Design View & in General Tab Go To "Validation Rule" & Edit Function with <A href="mailto:"InStr(1,[email],"@")>=1">"InStr(1,[email],"@")>=1"
& Creat A error Msg If u Want Please Note That In Above Syntex Second String "[email]" is Name Of Field For Which You want To Add Validation
http://www.daniweb.com/techtalkforum...top\access.bmp

Originally Posted by roamz101

Hey i am did this validation rule for a project i did 3 months ago, i readead your thread and found the way i did it. just place this text in to your validation rule field and it works a dream:
((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

it works perfectly and the company i just built a database for have no issues with it, it can even tell if someone enters " accedentally due to them not configuring their language settings properly. I hope all you guys out there find this useful.

cheers Remi