Determine which field in table triggered error 3314 or 3317 (required property=yes)

[MarcinM]

Hello,
I would like to have data validation at table level.

Let's assume that field's property "Required" is set to "yes" (error 3314) or data validation rule is "Is Not Null" (error 3317) and a table has multiple field, which cannot be null:
txtField_1
txtField_2
...
txtField_n

How can I determine which field triggered error 3314/3317 so that it is possible to display message box saying "Fill in field 1" or "Fill in field n" and afterwards set focus on that field if all the fields trigger the same error code without info, which field is null.

Thank you for any suggestions.

[twinnyfo]

There should also be a property in your Table for "Validation Text" which is the message that will pop up if someone enters an invalid entry. Your message can be tailored to the field to which it applies.