validating user input

  • Thread starter Thread starter MASB
  • Start date Start date
M

MASB

In a form, a textbox control is connected with a currency type field.

When user types 12ABC, access 2K generates an error message. I 'd like to
avoid this message and capture and process this error. - SetWarnigs false -
and -on error goto- did not work, (access message appears).
 
You can capture this in the Error event of the form.

DataErr 2113 indicates the data type is invalid.

Set the Response argument to acDataErrContinue to suppress the system
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

Data validation 16
Unfriendly error message in date field 3
Import files into access 1
Access Userform validation rule wont work - Please help 0
avoiding propogating error messages 8
Input mask error message 6
How prevent input mask appearing in locked date field? 1
Validate Required 2

Back
Top