Invalid Value for field

  • Thread starter Thread starter DZ
  • Start date Start date
D

DZ

When a user enter letters in a numeric field, and attempt to move out of the
field, MS Access displays a warning the "Value is not valid for the field."

Is there a way to not display that message and instead display a different
custom message
 
Use the Error event of the form.

That's the event that fires for engine-level errors.
You can trap the error number, and display your own message.
 
Back
Top