Why is this email validation expression form Microsoft not working?

[Accession]

Good day everyone,

I copied this expression/Validation Rule from Microsoft Website and placed it in the field (column) validation text rule. According to Microsoft, it is suppose to validate for the following: .com, .net, or .org e-mail addresses.

The problem is, when I first enter an invalid e-mail to check the validation rule, validation message fires up as expected. However, when I enter a valid e-mail address I still get the error message telling me to enter valid e-mail.

No matter what I do I keep getting the error message.



Here is the expression:

LIKE "[A-Z]*@[A-Z].com" OR "[A-Z]*@[A-Z].net" OR "[A-Z]*@[A-Z].org"

This is really killing me.

Thanks everyone.

Accession

[ajetrumpet]

I wouldn't doubt that MS is wrong. Allen Browne has a good one here:

http://allenbrowne.com/ValidationRule.html

not sure if that'll work for you though.

[Accession]

I wouldn't doubt that MS is wrong. Allen Browne has a good one here:

http://allenbrowne.com/ValidationRule.html

not sure if that'll work for you though.

Thanks a lot for responding, I did see the Allen Brown expression but I noticed it stopped short for looking for a dot com or dot something in an email address.

So I modified it like this: It will not allow emails with out dot something. It is not the best because the user can enter say: .c or .something with one letter, rather than com or net.

But I am just burnt out and will leave it this way.

Anyway this is what I have:

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

Thanks again.

Accession