Message Box Force new line

[hullstorage]

Hi all,

How do i force a newline in my message in the message box funtion

i.e. message would show like this

Hello World
Welcome to my World
How is yours

Thanks all

 

[boblarson]

MsgBox "Hello World" & vbCrLf & "Welcome to my World" & vbCrLf & "How is yours"

or you can use

Chr(13) & Chr(10)

instead of the vbCrLf constant (although I like that one better as it is less typing )

 

[MSAccessRookie]

Hi all,

How do i force a newline in my message in the message box funtion

i.e. message would show like this

Hello World
Welcome to my World
How is yours

Thanks all

If the MsgBox is in VB Coding, then add vbCrLf to the line

    MyMessage= MsgBox "Hello World" & vbCrLf & "Welcome to my World" & vbCrLf & "How is yours"

UPDATE:

Do What BobLarson Said. I was too slow, and he beat me to it again. I would like to add that if you are using macros, and not VB Code, then Chr(13) & Chr(10) will be way to go.