Enter Key

rwalker · April 7th, 2004, 10:29 AM

Is it possible to use the enter key to submit data in VB? If so, how? I can't seem to figure it out.

Thanks

Renee C. Walker

gbianchi · April 7th, 2004, 10:32 AM

hi there.. i think you have to be more explicit.. what do you want to submit with the enter key??
you can trap the key when is pressed..

HTH

Gonzalo

rwalker · April 7th, 2004, 10:37 AM

I want to save data to a database by pressing the enter key. I tried using the command button, but that doesn't work.

Renee C. Walker

gbianchi · April 7th, 2004, 10:41 AM

so.. you press the enter key and you do the stuff to save to the database..
where you have problems?? getting when the enter key is pressed??
saving the data to the database???
also, if you press the enter key when a command button has the focus, it's like clicking it...

HTH

Gonzalo

dunnie · April 7th, 2004, 10:42 AM

Hello
Try this
Private Sub txtInsp_KeyPress(KeyAscii As Integer)
    If KeyAscii = vbKeyReturn Then
        'Do your stuff here
    End If
End Sub

rwalker · April 7th, 2004, 11:04 AM

That Worked!!

Thanks

Renee C. Walker