Execute command in field when enter key is pressed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mmatzke@comcast.net - 06 Jun 2007 21:26 GMT

How can I get a command to execute when the enter key is pressed after
entering data?

Signature

Mark Matzke

Reply to this Message

Carl Rapson - 06 Jun 2007 22:48 GMT

> How can I get a command to execute when the enter key is pressed after
> entering data?

Handle the KeyDown event for the control, and check to see if the key
pressed was the Enter key:

If KeyCode = vbKeyReturn Then
' Execute your command here
End If

One note: the KeyDown event won't fire if you have a command button on your
form which has its Default property set to Yes. In that case, you may need
to use the KeyPress event instead.

Carl Rapson

Reply to this Message

DawnTreader - 31 Aug 2007 22:44 GMT

that was exactly what i was looking for. thanks.

i had to adapt one thing

If KeyAcsii = vbKeyReturn Then
' Execute your command here
End If

where does the KeyCode come into play? is it depending on the event that you
use it in? or is it just the variable you assign in the

Private Sub myField_KeyPress(KeyAscii As Integer)

thingy?

> > How can I get a command to execute when the enter key is pressed after
> > entering data?
[quoted text clipped - 11 lines]
>
> Carl Rapson

Reply to this Message