Hi Anson,
Thank you for your reply. The submit button does what I want, prevent submit from occuring if there are validation errors in the form.
The Save or Save As buttons are the issue. This is because it will prompt the user if there are errors, but the prompt allows the user to continue with the save. I want to disable saving if there are validation errors.
I am currently utilizing custom code in the save event handler that checks a couple fields to see if they contain a prohibited value, if so exit sub (prevent saving). I could continue with this approach using custom code for all the fields that have validation, but this would be exhaustive and require heavy ongoing maintenance.
It seemed to me that there may be some VB code that could count or true/false if there are validation errors in the form.