Google Answers Logo
View Question
 
Q: Microsoft Access Data Validation ( No Answer,   1 Comment )
Question  
Subject: Microsoft Access Data Validation
Category: Computers > Software
Asked by: tristan47-ga
List Price: $5.00
Posted: 15 Jul 2003 14:00 PDT
Expires: 14 Aug 2003 14:00 PDT
Question ID: 231368
I have validatation rules for a microsoft access table.  Something is
driving me crazy though.  If somebody starts entering a record (maybe
just hits one too many tabs) it's almost impossible to delete it since
the data validation error boxes pop up when you try to do anything! 
Is there an elegant solution?
Answer  
There is no answer at this time.

Comments  
Subject: Re: Microsoft Access Data Validation
From: bbnh-ga on 17 Jul 2003 14:31 PDT
 
It sounds like you might have validation on one or more fields in the
table.  If you start keying something on a new records in a field with
validation and then try to get out of that field (e.g. tab), Access
will keep prompting you.

The easiest thing I know is to use the Escape (Esc) key (after you say
OK or whatever on the popup message box).  The first Esc press
"undoes" the field you are on, making it as if you never went there. 
If you press Esc a second time after that, it will un-do the whole new
record you're entering -- that is sort of like "deleting" the new
record... before it's saved.

The two levels of undo caused by two successive Esc key presses is not
obvious, but quite useful.

Not sure if that's elegant enough for you, but it's my two bits.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy