Key Event

[jazz823]

I have a datagrid that has a notes column, I want the user to be able to hit enter in the grid and have it go to the next line like when ctrl enter is hit.

In other words I want to program the enter key to be the ctrl enter key for that datagrid. Thanks

Jim

[BrianS]

See if this helps:

http://www.vbforums.com/showthread.p...hreadid=245462

[techyspecy]

Originally posted by jazz823
I have a datagrid that has a notes column, I want the user to be able to hit enter in the grid and have it go to the next line like when ctrl enter is hit.

In other words I want to program the enter key to be the ctrl enter key for that datagrid. Thanks

Jim

Option Explicit
 
Private Sub DataGrid1_KeyPress(KeyAscii As Integer)
    On Error Resume Next
    If KeyAscii <> vbKeyReturn Then Exit Sub
    DataGrid1.Row = DataGrid1.Row + 1
    On Error GoTo 0
End Sub

[jazz823]

Thanks Marc and others,

Marc your suggestion sent me to the next row, where I was looking to go was a new line like a carriage return, so that the note can continue in the same line. I did not want the end user to have to remeber ctrl+enter

Thanks