Escape Key Not Working On Certain Fields

[jhaganjr]

What I consider "normal" behavior is when data is typed into a field on a form or a selection is made in a combo box, pressing the Escape key once will Undo the typing or the selection.

For most fields on my form the Escape key does just that.

But there are several fields on the form where pressing Escape does NOT undo what was just done in that field. Whatever changes were made to the field are still there after pressing escape. Only the Undo command will get rid of the field changes ... but then that Undoes the entire record.

I can't find any kind of setting that's causing the Escape key to behave differently for certain fields on the form.

Anybody have any clue? Thanks.

Joe

 

[vbajock]

Don't know what causes it, but this code inserted in the keypress event of the field will fix it:

Private Sub Text0_KeyPress(KeyAscii As Integer)


If KeyAscii = 27 Then
Me.Text0 = Me.Text0.OldValue
End If


End Sub

 

[jhaganjr]

Thanks vbajack,

That's useful and on the money.