I have put in a custom input error message for when the user does not enter a valid input mask. The code is as follows...
In the forms properties onerror I have...
Private Sub Form_Error(DataErr As Integer, Response As Integer)
Const INPUTMASK_VIOLATION = 2279
If DataErr = INPUTMASK_VIOLATION Then
MsgBox "Sorry that is not a valid postal code.", , "Input Error"
Response = acDataErrContinue
This works however lets say the user decides I just want to exit the form. When they press the exit button the error message pops up and the user cannot exit unless they erase the entry in the text box of have a properly formatted input.
Any ideas how to let the user exit