Field Validation

  • Thread starter Thread starter iam
  • Start date Start date
I

iam

I have a text field on my database set to:

Require Yes
Allow Zero Length No

I am still able to hit enter AND tab without a problem.
What I want is when I hit enter OR tab an error box to come up.

Where do I put the code for this.
On the Validation Rule on the form or on the validation rule for the
field itself.
 
You would have to build code in the field's exit or change event.

Validation rules only apply when you try to save the record.

Rick B
 
If this is a new record, the Required property won't cause any error until
and unless you attempt to save the record. In a form, you could add some
text to the Exit event of the text box to check that data has been entered.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
If this is a new record, the Required property won't cause any error until
and unless you attempt to save the record. In a form, you could add some
text to the Exit event of the text box to check that data has been entered.
Click to expand...
Thanks!
 
Back
Top