macro message box - line break

[tweety]

i have a macro with a message box running, the message is now very long and id like it to be on 2 lines rather then 1



any ideas, thanks

[June7]

Use Chr(13) & Chr(10)

"This is example of text " & Chr(13) & Chr(10) & "with multiples lines created " Chr(13) & Chr(10) & "by concatenation of Cr and Lf codes."

[tweety]

iv tried that code it doesnt work for me, i also copied the entire line and tried, still no luck :-(

[June7]

Works in textbox ControlSource or in query or in VBA. However, I don't use macros so I just tested this. I see that it just prints the codes as literal text. What a bum deal. Another limitation of macros.