Re: acc97, control.undo not restoring old value

[Keith Wilby]

"Phil Stanton" <ph**@myfamilyname.co.ukwrote in message
news:Oc******************************@posted.plusn et...

You might try

Private Sub MyControl_BeforeUpdate(Cancel As Integer)

If Nz(MyControl) = "" Then
MsgBox "Someting required"
Cancel = True
SendKeys "{ESC}"
End If

End Sub

AIUI the SendKeys method is frowned upon because it can send to whatever
window has the focus, be it your Access application or anything else.

Keith.

[Salad]

Keith Wilby wrote:

"Phil Stanton" <ph**@myfamilyname.co.ukwrote in message
news:Oc******************************@posted.plusn et...

>You might try

Private Sub MyControl_BeforeUpdate(Cancel As Integer)

If Nz(MyControl) = "" Then
MsgBox "Someting required"
Cancel = True
SendKeys "{ESC}"
End If

End Sub

AIUI the SendKeys method is frowned upon because it can send to whatever
window has the focus, be it your Access application or anything else.

Keith.

That may be true. But if your form has focus, and the app is Access,
and you are doing a Sendkeys, how could it be sending the Sendkeys value
to any other window?

[Keith Wilby]

"Salad" <oi*@vinegar.comwrote in message
news:wZ******************************@earthlink.co m...

>
That may be true. But if your form has focus, and the app is Access, and
you are doing a Sendkeys, how could it be sending the Sendkeys value to
any other window?

Supposing you have a long procedure in your app and your user clicks on
another window whilst it runs. What would the SendKeys method do then?