Next line of Msgbox, not sure how to do

[haveli1]

Does anyone know how to put a specific part of a text of a message box on the next line.

MsgBox("Click OK and Immediately Insert the ID " & right(Me.Discl, 2) & "-" & Me![Number] & ".")

I would like the numbers to be on the next line. So it would read


"Click OK and Immediately Insert the ID

12-14"

if the numbers were 12 and 14.
Is this possible? Thanks.

 

[elbweb]

try this:

MsgBox("Click OK and Immediately Insert the ID " & vbCrLf & right(Me.Discl, 2) & "-" & Me![Number] & ".")

never tried it in a message box, but thats the best idea i've got.. and im no where to test right now

edit: for clarification vbCrLf is Visual Basic Carriage Return Line Feed or something like that, its one of the many things that you can't do through code, so there is a vb statement representing them more info here: http://support.microsoft.com/?kbid=211774

 

[ampatel2]

vbNewLine

'try this
MsgBox("Line 1" & vbNewLine & "Line 2")