Re: Cancel, Undo and Null

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Allen,

Hmm... That's a bit naff - The user is going to hit the
Cancel button and and it's not going to Cancel.
So is there no way to simulate the escape key, or
clicking the Undo button on the Toolbar, or choosing
Undo from the Edit menu in VBA ?
I suppose I could always hunt for the rouge text
box with a null in it, and put something in it and
then do the undo. Trouble is I don't know if it's
the Save button or the Cancel button that has
been hit,

Hmmm

Thanks for your help,
Roy

"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:%23Ew4sFxqFHA.2592@xxxxxxxxxxxxxxxxxxxxxxx
> That's correct: if you place a command button on the form, you cannot get
> out of a required field to get to the cancel button by backspacing the
> characters.
>
> Instead, undo the entry by pressing the <Esc> key.
> Or by clicking the Undo button on the Toolbar.
> Or by choosing Undo from the Edit menu.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>


.

Relevant Pages

  • RE: Error 2115 with cancel and undo?
    ... If the user tries to uncheck ... Using the ever so common Cancel and Undo concepts may work ... the first time I uncheck any box, it does the undo and cancel for me ...
    (microsoft.public.access.forms)
  • Error 2115 with cancel and undo?
    ... If the user tries to uncheck ... Using the ever so common Cancel and Undo concepts may work ... the first time I uncheck any box, it does the undo and cancel for me ...
    (microsoft.public.access.formscoding)
  • Error 2115 with cancel and undo?
    ... If the user tries to uncheck ... Using the ever so common Cancel and Undo concepts may work ... the first time I uncheck any box, it does the undo and cancel for me ...
    (microsoft.public.access.forms)
  • Error 2115 with cancel and undo?
    ... If the user tries to uncheck ... Using the ever so common Cancel and Undo concepts may work ... the first time I uncheck any box, it does the undo and cancel for me ...
    (microsoft.public.access.modulesdaovba)
  • RE: User Saving a Record else it deletes
    ... The code I posted simply does not undo if the user clicks no, ... > or tries to exit. ... >> Make a Cancel button on the form, ... >> End Sub ...
    (microsoft.public.access.forms)