Suppose you have a button that uses a
Default property (set to true) and are editing text in a multiline text box on the same form. When you press the enter, the button's click event fires rather than having a new line added to the text box.
Placing the following code into your click event on the default button on your form enables you to use a default button and a multiline text box on the same form. Basically, this code checks which control has the focusif it's a multiline textbox, the code cancels the button's click event. You then have to send a newline to the text box manually.
Private Sub cmdOK_Click()
Static ignoreClick As Boolean
If ignoreClick = False Then
If TypeOf ActiveControl Is TextBox Then
If ActiveControl.MultiLine = True Then
SendKeys vbCrLf
ignoreClick = True
Exit Sub
End If
End If
Else
ignoreClick = False
Exit Sub
End If
' normal code for the OK button would go here...
End Sub