Typing data twice (control of data entry)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to enter date twice to make sure that data are correct before
they are stored? Is it possible to make the data invisible before the second
entry, to prevent that the operator is biased by the first entry?
 
Yes, it would probably be best done by using a second textbox for the check
entry. There are two options on hiding the first entry.

1) You could set the first textbox's Input Mask to Password. This will cause
it to show asterisks as the user types.

2) In the AfterUpdate event of the first textbox, set its Visible property
to No and the second textbox's Visible property to Yes, then SetFocus to the
second textbox. This would allow you to place both textboxes on top of each
other so that they didn't occupy any extra room on the form.

In the BeforeUpdate event of the second textbox, you would verify its entry
with the value of the first textbox. If they don't match, pop-up an error
message and react accordingly.
 
Back
Top