Email address validation

[mattieflo]

Hello,

I'm currently using the following validation rule for emails in my form.

Like '*@*.*' And Not Like '* *'

This is just a simple way to check whether the correct format is being used
for e-mails.

However, I've run into a problem that if a user deletes an e-mail address
that is on the form and wants to leave it blank, it triggers this validation
check. Does anyone know what statement I can write to allow a deleted address
to go through? I can delete the email address from the back table but I don't
want to do that every time.

Thanks!

 

[Allen Browne]

Try:
Is Null OR ((Like "*?@?*.?*") AND (Not Like "*[ ,;]*"))

Explanation of this and other rules, see:
Validation Rules
at:
http://allenbrowne.com/ValidationRule.html

 

[mattieflo]

Worked like a charm. Thank you Allen!

Try:
Is Null OR ((Like "*?@?*.?*") AND (Not Like "*[ ,;]*"))

Explanation of this and other rules, see:
Validation Rules
at:
http://allenbrowne.com/ValidationRule.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hello,

I'm currently using the following validation rule for emails in my form.

Like '*@*.*' And Not Like '* *'

This is just a simple way to check whether the correct format is being
used
for e-mails.

However, I've run into a problem that if a user deletes an e-mail address
that is on the form and wants to leave it blank, it triggers this
validation
check. Does anyone know what statement I can write to allow a deleted
address
to go through? I can delete the email address from the back table but I
don't
want to do that every time.

Thanks!