Detect key pressed in Access VBA

[Abe Katz]

Hello,
How can I detect which key was pressed in Access 2003
Thanks in advance
Abe

 

[Douglas J. Steele]

Detect which key was pressed where?

Most Form controls (text box, combo box, etc.) have a KeyPress event that
you can use.

 

[Abe Katz]

Thanks Doug,
I want to use it on a form. When the enter-key is pressed, I want to run an
event.

 

[Douglas J. Steele]

Set the form's KeyPreview property to True, and you can then use the form's
KeyPress event.

Private Sub Form_KeyPress(KeyAscii As Integer)

If KeyAscii = 13 Then
MsgBox "You hit Enter"
End If

End Sub