link a button to a text box 1

[Stuartp]

How can I link a button to a text box on a form so that the user can type something into the text box and then press the Enter key on the keyboard and it will execute the code behind the button as if the user had clicked the button with a mouse.

I know I can assign shortcuts to buttons like Ctrl-A or whatever, but the Enter key would be more convenient espeically for application using search features.

Thanks,

Stuart

 

[jsnull]

Your code would look something like this, to execute a command button after some text has been entered into a text box:

Private Sub Command1_Click()
' do something
MsgBox "Hello"
End Sub

Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then 'if enter key is pressed
Call Command1_Click
End If
End Sub

 

[venom3249]

You could also just set that button's default property to TRUE and it will work also.