Error Trapping - 2779 Validation rule

T

TonyT

Hi,

I have a form that contains 2 fields with validation rules - Postcode and
Account Number, both of which are set to capitals and other criteria.

I have an error trapping routine in Form_Error to pick up on error 2779 and
display a message, but I would like to be able to identify which field caused
the error and give an accurate prompt to comply with each fields different
validation rules.

many thanks in advance.
 
A

Allen Browne

If the user is entering the data (i.e. you are not poking it in
programmatically), Form.ActiveControl should give you the name of the
control that triggered the error.
 

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

Top