Access not picking up Enter Key

tkepongo · #1 (**permalink**) 01-26-12, 16:40

I'm trying to run a query when a user hits the Enter key in a textbox. On my workstation, everything runs fine. However, on some machines, Access isn't recognizing the Enter key being pressed. Here's an example code

Code:

Private Sub Receipt__KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
MsgBox ("derp")
Else
MsgBox ("herpity derp")
End If

As I type in the textbox, Access will display "herpity derp" but when I hit the Enter key, it skips to the next textbox. What am I doing wrong?

Sinndho · #2 (**permalink**) 01-26-12, 16:54

Check the "Move after Enter" option parameter. In Access 2003 it's in the Options Menu --> "Keyboard" tab.

You can also use the KeyDown event instead of KeyEnter.

tkepongo · #3 (**permalink**) 01-26-12, 16:57

Quote:

Originally Posted by Sinndho

Check the "Move after Enter" option parameter. In Access 2003 it's in the Options Menu --> "Keyboard" tab.

You can also use the KeyDown event instead of KeyEnter.

We have Access 2007 and I can't find any option for Keyboard

Sinndho · #4 (**permalink**) 01-26-12, 17:43

Click on the "Office" button (upper-left corner) then click on the "Access Options" button and select the "Advanced" group.

Internet Services

Web Development

Digital Marketing

Consumer Tech