field validation

[patti]

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

 

[Rick Brandt]

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.

 

[patti]

thanks rick!

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.