How and when to use Validation Rules on your fields and tables, in Microsoft Access databases. If you need to be able to leave the field blank, add OR Is Null to your rule. (Some versions accept Date(). Email address, Is Null OR ((Like "*?@?*. Should you create a rule to ensure the user doesn't enter a future date?