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
 
Back
Top