field validation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

patti - 04 May 2007 02:48 GMT

is gthere a way to vaildate field by field? i mean, focus remains locked on
control until requirements are met before field moves to next control?

thanks.

patti

Reply to this Message

Rick Brandt - 04 May 2007 03:05 GMT

> is gthere a way to vaildate field by field? i mean, focus remains locked on
> control until requirements are met before field moves to next control?

Sure, use the BeforeUpdate event of the control and set the Cancel argument to
true when the validation fails. That of course won't help if they never enter
anything in the control at all so you also need to test in the BeforeUpdate of
the form.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

patti - 04 May 2007 21:47 GMT

thanks rick!

> > is gthere a way to vaildate field by field? i mean, focus remains locked on
> > control until requirements are met before field moves to next control?
[quoted text clipped - 3 lines]
> anything in the control at all so you also need to test in the BeforeUpdate of
> the form.

Reply to this Message