By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,046 Members | 1,775 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,046 IT Pros & Developers. It's quick & easy.

Clearing a field after validation rule pop-up window

P: 2

I have a form in which there are fields that have validation rules for the quantity and types of characters that are entered by the people on the production floor. The operators are wanting me to refine this so that if they accidentally enter or scan the wrong information, the affected field will automatically be cleared of the previously-entered contents (after they clear the validation error pop-up window). How can I accomplish this?

Jun 29 '12 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,419
From the keyboard you would use the <ESC> key. From code you would use the .Undo() method (either for the form itself or just the control).
Jun 30 '12 #2

P: 2
Your recommendation of pressing <ESC> only seems to default and highlight the previously-entered record. What I am trying to do is just delete the field. Thanks.
Jul 2 '12 #3

Expert Mod 15k+
P: 31,419
Clearing the entered data back to the initial value of the record is what your post asked for. Deleting a field is meaningless (as far as an operator is concerned). You can only clear the contents of a field on a form. Selecting the contents and pressing <Del> would generally do that for you, but that depends on what type of control and field and ...

Essentially though, the answer to your original question is in my earlier post.
Jul 2 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.