The value you entered isn't valid for this field

[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)!!

 

[Allen Browne]

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.

 

[a]

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

 

[Allen Browne]

Add the line:
Stop
in Form_Error, and you can ask what DataError is.

2113 = wrong data type.