MsgBox how to go on a new line

[Paolo]

I am trying to have a message box where the message goes onto a second line

My book is for Access 2000 and I am using 2002. I have tried using the @
sign but it's not working....

Any suggestions?

Thanks guys...

[Darryl Kerkeslager]

vbCrLf

Darryl Kerkeslager
"Paolo" <pr*****@netspace.net.au> wrote in message
news:cs***********@otis.netspace.net.au...

I am trying to have a message box where the message goes onto a second line
My book is for Access 2000 and I am using 2002. I have tried using the @
sign but it's not working....

Any suggestions?

Thanks guys...

[Randy Harris]

"Paolo" <pr*****@netspace.net.au> wrote in message
news:cs***********@otis.netspace.net.au...

I am trying to have a message box where the message goes onto a second line
My book is for Access 2000 and I am using 2002. I have tried using the @
sign but it's not working....

Any suggestions?

Thanks guys...

Paolo, the use of '@' for a line break is obsolete, it no longer works. You
can use vbCRLF, however:

MsgBox "This is the first line" & vbCRLF & "This is the second"

Hope that helps

[Trevor Best]

Randy Harris wrote:

"Paolo" <pr*****@netspace.net.au> wrote in message
news:cs***********@otis.netspace.net.au...

I am trying to have a message box where the message goes onto a second

line

My book is for Access 2000 and I am using 2002. I have tried using the @
sign but it's not working....

Any suggestions?

Thanks guys...

Paolo, the use of '@' for a line break is obsolete, it no longer works. You
can use vbCRLF, however:

MsgBox "This is the first line" & vbCRLF & "This is the second"

Hope that helps

You can still use the @ formatting if you use the Access msgbox rather
than the VBA.Interaction one, e.g.

Eval("Msgbox(""Hello@There@""))

You can also save some typing and 3 bytes (2 for code, 1 at runtime) by
using vbCR instead of vbCRLF :-)
--
This sig left intentionally blank