Is this a bug in Access 2013 - with accdb files attached

[Eli Naiman]

See attached accdb files

In Form1 Key Preview is set to YES
When you press the ESC key the application exits.

However if you click on Button1 the ESC key does not work anymore.
Button1 just does
DoCmd.TransferDatabase acLink, "Microsoft Access", "c:/Test1/BackEnd.accdb", acTable, "Table1", "Table1"
DoCmd.DeleteObject acTable, "Table1"

[ADezii]

The trick is to place the Code in the Form's KeyDown() Event and NOT the KeyPress() Event (KeyPreview = Yes):

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
Const conESCAPE_KEY = 27
 
If KeyCode = conESCAPE_KEY Then
  DoCmd.Quit acQuitSaveAll
End If
End Sub

[Eli Naiman]

Thank you. This is a work-around that works. I still think it is a bug that should be fixed.