custom error handling

[Sergey Bogdanov]

Hello,

I'm wondering if someone can tell me about custom error handlign. I mean
that there are errors on the form where I try to leave the blank page like
required field. It shows to the user error message 'The field
"Deliveries.Date" cannot contain a Null value because the Required property
for this field is set to True...".

Is it possible to handle this error and replace it with my own Custom dialog
with my own "User-friendly message"? By the way, is possible to somewhere
get description to field for which error occured?

Thnx in advance,
Sergey

 

[Pete Duffy]

You can put any message you want in the properties for the field/object
under validation text which is right after validation rule. If you really
want to get fancy you can move to VBA and add complete error routines. This
is a huge subject with many different opinions but you could start with this
MS solution at;
http://support.microsoft.com/default.aspx?scid=kb;en-us;101324

Might also think about a book like Access XXXX Developers Handbook Vol 1.
It has good coverage of the subject and many others. The XXXX stands for
access version your using.