Has anyone ever found a way to trap this error message and provide the user with a different message and even undo the field entry? So far, I have not found any solutions. The error happens before the LostFocus, Exit, BeforeUpdate events of the control.
I tried creating a function that would run in the OnValidate. It seemed to work to a point, but was unreliable.
To see what I'm talking about in action and to provide a working solution in a sample form I have uploaded a small database.
Open Form1. Enter 130pm in the MyDate field and you will get the error I'm referring to.