Line Break in MsgBox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone tell me how to force a line break in the message text in a msgbox?

Thanks!

Scott
 
I guess there is truth in the cliche, 'you learn something everyday'. I have
always used VbCrLf for that. I have never before known about vbNewLine
 
I guess there is truth in the cliche, 'you learn something everyday'. I have
always used VbCrLf for that. I have never before known about vbNewLine
Click to expand...

There is also
chr(13) & chr(10)
(in that order) as well as
vbCr & vbLf

MsgBox is an application wide object, not just an Access object.
In MsgBox, you can even use either:
chr(10)
or
chr(13)
or
vbLF
or
vbCr
by itself.

I don't like to show just the one by itself because other Access usage
requires both, and using vbNewLine or vbCrLf or chr(13) & chr(10)
keeps MsgBox consistent with other Access/VBA usage.
 
I have
always used VbCrLf for that. I have never before known about vbNewLine
Click to expand...

vbNewLine is guaranteed to be appropriate for the operating system of the
moement. With Access, that is obviously redundant, but I _think_ that VBA
is available on Word, Excel, etc on the Mac isn't it?

Tim F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Editor skips lines and moves to other part of code 4
VBA Multiple Line handling with Split() 1
New line in msgbox 2
Formatting text in a label or text box 3
Faking form as MsgBox 7
MsgBox line break 1
msgbox multiline 7
Excel Need assistance with modifying a Duplicate declaration. 13

Back
Top