Validation Rule/Text

[Helen]

Good day,

Brand new to Access 2003. Having fun? Not yet.

Anyways. I entered the following Validation Rule (for the Email field Name):
Like "*@*.???" and the Validation Text is Not a valid Email address.

When I enter an email address on the form (i.e. (e-mail address removed)), all I
get is the validation text (Not a valid Email address).

In order to avoid this, how should the Validation Rule be written?

Thanks!

 

[Wayne-I-M]

Hi Helen

Have a look at the answer given by Van TDinh to the same question

http://groups.google.com/group/micr...2a0ea904d9f?lnk=st&q=&rnum=3#035dd2a0ea904d9f

Good luck