"tab" or "enter" keystroke

[crowegreg]

Is their any way to determine if the user pressed the "tab" key or the "enter" key? I'd like to preform different events after determining which keystroke the user performed.

 

[vbaInet]

You can use the Key Down or Key Press events of the control you wish to trap or the form. I think the code is 9 for tab, can't remember.

If you're going to trap it at form level, you will need to set the KeyPreiew property of the form to Yes.

 

[crowegreg]

Can you provide a little more detail to your solution. Thanks!!

 

[vbaInet]

Let's say you have a texbox called Textbox1 and you want to trap when a user Tabs from that textbox, you would do this in the Key Press event or the Key Down event of the textbox. Look in the property sheet of the textbox under the "Event" tab and you will these events I've mentioned.

For the Key Down event, put the following line of code:

    MsgBox "KeyCode: " & KeyCode

Then open your form in design view, put the cursor inside the textbox and tab out.

 

[crowegreg]

That helps alot. Thanks

 

[vbaInet]

You're welcome!