Multiple lines in msgbox

R

Ray

I have the following code
MsgBox "Please select a Form or Report", 64, "Incomplete Request"

I would like to put more text in the message but I want it on two lines
rather than just 1 long line.

example: "Please select a Form or Report"
"from the list below."

rather than: "Please select a Form or Report from the list below."

Any suggestions???
 
T

Tom

Hi Ray,
put vbCrLf between the 2 lines
i.e MsgBox "Please select a Form or Report" & vbCrLf & "from the list
below.", 64, "Incomplete Request"
 
C

Chris

Ray,
To move to the next line in a message box you need the & VbCrLF. See sample
below.

Private Sub Command0_Click()
Dim s As String
Dim dr As Integer
s = "Please Select A Form Or Report" & vbCrLf & "From The List Below"
dr = MsgBox(s, 64, "Incomplete Request")
End Sub

HTH,
Chris
 
Top