473,405 Members | 2,160 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

Clearing a field after validation rule pop-up window

2
Hello,

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?

Thanks
Jun 29 '12 #1
3 2301
NeoPa
32,556 Expert Mod 16PB
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
galkej
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
NeoPa
32,556 Expert Mod 16PB
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

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

Similar topics

2
by: Doslil | last post by:
I am trying to validate the fields in my database.I have already validated the fields to check for not null.Here is what I have written for Numeric and text field. Private Function EENUM() On...
2
by: Joey P | last post by:
Hi all, I am doing a project for university whereby i have to implement a simple database related to a frozen foods company. I am having some trouble though creating a validation rule for one...
5
by: Paul Krasucki | last post by:
This is for a search page that takes parameters on one page, processes the query, and displays them on another page. I've got a javascript popup window on a button click event. When the user...
1
by: Matt Jensen | last post by:
Howdy I've got a ASP.NET webform page that pops up a window for a user to make a selection. Once they make a selection in this popup window, the form in the popup is submitted an update to the...
3
by: EnjoyNews | last post by:
I have a popup problem. I have a script that generates a popup for image viewing. It has 2 function, and the first is that it automaticly generates the popup window to the size of the image,...
3
by: jasons4u2 | last post by:
i have two fields PROJECT START DATE and PROJECT END DATE. now i want to creat a validation rule so that the Project End Date will be greater than the Project Start Date. Can any one please help...
1
by: bruce.dodds | last post by:
I would like to set up a field validation rule to limit first name characters to alphabetic characters, period, and space. I've tried a number of variations on this rule: Is Null Or...
3
by: JJ297 | last post by:
After a user clicks the submit button I want a window to come up telling them your entry has been submitted. I have this code in my page load section which works well. ...
1
by: MLH | last post by:
Anyone remember if A97 append query failure would ever report data breaking validation rule when such was not the case. I have an old SQL statement - several years old now. I've encountered a case...
8
by: Kaloyan Krumov | last post by:
Here is the setup: table field validation rule Is Null Or Not Like "**" in Form i have textbox that automatically (inputmask) fills in the country phone code Dim mask As String mask = ""...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.