Email Validate

[Robert Raley]

Access 2003

I would like to run a query to select the Email that are not in a proper
format for Email. Any one have and Idea how to do this.

Thanks

Robert M. Raley

 

[CSmith]

Hi,

You might not be able to catch all of them (like international or TV email
addresses for example). However, an expression like the following might be
of help to get you started.

IsValid: IIf(InStr(1,[EmailAddresses],"@") And Right([EmailAddresses],3) In
('com','org','net','edu','gov'),-1,0)