get out of control

[alex]

using Access '03...

Allen Browne wrote this a few years ago:

/"Note that an undo button on a form is of limited use. If you are in
the
/process of entering something invalid, Access won't let you out of
the
/current control until you fix that. Consequently you can't even get
to the
/undo button if the current entry is invalid (such as 1/1/ in a date
field,
/or backspacing all characters out of a required field.)"

I have a form with a few validation rules...while I'm testing the
form, what Allen said above is quite apparent.

Let's say a user gets halfway through entering a new record; hits a
field with a validation rule on it and becomes frustrated and changes
his/her mind about entering the record or just wants to start over
(even though you have good validation text).

Is there a cmd button with code that will cancel adding/saving the
record that's currently being added?

alex

 

[Brian]

Normally the keyboard [Escape] key will undo the field

 

[alex]

Normally the keyboard [Escape] key will undo the field

using Access '03...

Allen Browne wrote this a few years ago:

/"Note that an undo button on a form is of limited use. If you are in
the
/process of entering something invalid, Access won't let you out of
the
/current control until you fix that. Consequently you can't even get
to the
/undo button if the current entry is invalid (such as 1/1/ in a date
field,
/or backspacing all characters out of a required field.)"

I have a form with a few validation rules...while I'm testing the
form, what Allen said above is quite apparent.

Let's say a user gets halfway through entering a new record; hits a
field with a validation rule on it and becomes frustrated and changes
his/her mind about entering the record or just wants to start over
(even though you have good validation text).

Is there a cmd button with code that will cancel adding/saving the
record that's currently being added?

alex- Hide quoted text -

- Show quoted text -

You may be onto something Brian...I'll test it. Thanks!

 

[John W. Vinson]

Normally the keyboard [Escape] key will undo the field

And hitting it twice in succession will undo the entire record.

 

[John Spencer]

Actually hitting it once can undo the entire record.

If you are in a control and make a change and press escape you undo the
change to the control. Then a second time you press escape you will
undo the changes to the form.

If you are in a control and have not yet made any changes to the
control's value (text) then press escape you will undo all changes to
the form.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Normally the keyboard [Escape] key will undo the field

And hitting it twice in succession will undo the entire record.

 

[John W. Vinson]

Actually hitting it once can undo the entire record.

If you are in a control and make a change and press escape you undo the
change to the control. Then a second time you press escape you will
undo the changes to the form.

If you are in a control and have not yet made any changes to the
control's value (text) then press escape you will undo all changes to
the form.

Interrreesssstingggg...

Wasn't aware of that, thanks John!