Outlook Validation Formulas and Messages:
Return to List
' NOTE: NEVER use the checkbox A value is required for this field because Outlook doesn't tell the User which field is blank (forcing the User to inspect the form) and the message doesn't appear until the form is closed. Better to Validate the fields before closing the form and simply check to see that it's not equal to a zero-length string (as shown below).
' NOTE: Validation is a positive assertion.
' Some validation examples include: [Project] <> "" ' You cannot leave the Project field blank. [Due Date] > Date()' Enter a Due Date later than today's date. Len([Project Code]) = 10' The Project Code must be exactly 10 characters.
' CAUTION! - Before you delete a control from a form, check its Validation properties. If validation is active and you remove the field from the form, Outlook still tries to validate it. The User will almost always get an error message, but will not be able to correct the error because the control is no longer present on the form!