I have a form that has an email field. I have a validation rule of:
Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))
to help ensure the email is entered fairly accurately. For the most part it works great. However if a user pastes text into the field that has a space at the start of the text the validation rule fails.
Is there a way to incorporate trim into the validation rule or perhaps run after update VBA code to validate the form and trim it instead?