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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The value you entered isn't valid for this field 3
Validation Text 1
Error message - unique index created on two different fields 3
DCount alwaysreturning 1 0
Need combo box to refresh when moving to new record 2017 1
Access Test if value is less than percent 0
Suppress "0" in numeric text box 4
Import files into access 1

Back
Top