validation rule issue

[officemanager2]

Hi There: I've added in the following validation rule for emails put into the database:

((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

The problem is when the end user makes a mistake the field is now active and will not allow the end user to tab to the next field even if they decide to leave the email field blank.

Any suggestion to allow the enduser to skip the email field if they decide to not enter it once they have begun entering the information?

 

[officemanager2]

Ok, I was able to figure this out.

Add the following 'Or Is Null'

So it looks like

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