Field Validation

S

Shree

Hi!
I have a question about field validation.
I have set a validation rule for a textbox. It allows me
to enter only F or M in the box.I entered a Z by mistake
and tabbed over to the next field. Natually I got a
message box saying that I need to type a F or M. Then for
some reason I decided to leave the field blank for the
moment.The problem is, it would not let me delete the z
and tab over to the next field. I could not close the form
or go to next field without typing an F or M in it. How
should I solve this problem...If I type something in the a
field that has validation and then decide to delete it and
go to the next field, why wont it let me? Please help.
Thanks in advance.
Shree
 
J

Jim Allensworth

Just use <Esc>. When you delete an entry you are still making an
change - and it's not F or M, it's Null.

- Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top