The value you entered isn't valid for this field

  • Thread starter Thread starter a
  • Start date Start date
A

a

The value you entered isn't valid for this field

for example, you may have entered text in a numeric field or a number that
is larger the field size permits

this message appear for me on my (((Form))) when entering:

text or number in ---------date field

text or date in ------------ number field

my question is:

is there any why to remove this message and display custom message after
typing directly (after update) for the (Control)!!
 
This is an engine-level message, so you can use the Error event of the form
to catch it and substitute your own message for that DataErr.
 
thank yoiu
can you give me list off error and error no

becuse i search in access help i can't find any information
example:
case erro no
case dublicate index 21125

so i can take number and deal with in VBA
 
Add the line:
Stop
in Form_Error, and you can ask what DataError is.

2113 = wrong data type.
 
Back
Top