Breaking a Dialog Box/MsgBox) into 2 lines 2

[WallT]

Can somebody please help me with this. How can I have a message break into two lines using the Access Message Dialog Box? Some of my messages are detailed and real long:


MsgBox "Blah Blah Blah extra long message", vbCritical

I tried this without success...maybe somebody can fix this for me:

MsgBox "Blah Blah Blah" & Char(13) + Char(10)& "Extra long message", vbCritical

 

[PHV]

And what about this ?
MsgBox "Blah Blah Blah" & vbCrLf & "Extra long message", vbCritical

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[WallT]

That's perfect...thank you again.

 

[TheAceMan1]

How are ya WallT . . .

Here's a sample:

[blue]   Dim Msg As String, Style As Integer, Title As String
   Dim NL As String, DL As String
   
   NL = vbNewLine [green]'NewLine[/green]
   DL = NL & NL   [green]'DoubleLine or Line Space[/green]
   
   Msg = "Line1" & NL & _
         "Line2 (on newline)!" & DL & _
         "Line3 (after line space)!"
   Style = vbInformation + vbOKOnly
   Title = "Test Lines! . . ."
   MsgBox Msg, Style, Title[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[orna]

Try the Eval with the msgbox and you'll get the first line emphasised