Hard Cr in Macro Message Box.

[JHB]

Hi:

I have a macro that includes a message box in which I wish to have two
lines. I am having a problem figuring out how to make the line break.
Line One&cr&Line two does not work. In fact nothing that I have tried
works!

Your help would be much appreciated.

John Baker

 

[fifa2001]

Hi:

I have a macro that includes a message box in which I wish to have two
lines. I am having a problem figuring out how to make the line break.
Line One&cr&Line two does not work. In fact nothing that I have tried
works!

Your help would be much appreciated.

John Baker

 

[Daniel Pineault]

Try

LineOne & VbCrLf & LineTwo
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[John Spencer]

If that fails then try using Chr(13) & Chr(10) between the two strings.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County