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.
 
Back
Top