Formating Message Box to more than 1 line

[Les]

Is it possible to format a message onto more than 1 line in a popup box?

From the following message I would like the part in capitals on a separate
line in the box.

msg = MsgBox("You have changed the Address Details do you wish to keep these
changes? CHOOSING NO WILL RESET ALL PERSONAL DETAIL CHANGES MADE THIS TIME",
vbCritical + vbYesNo, "CHANGING RECORD ")

Les

 

[Les]

Thanks Peter thats great!

Les,




msg = MsgBox("...changes? " & vbCrLf & "CHOOSING ...

HTH - Peter

 

[PC Datasheet]

You may be interested in knowing that

msg = MsgBox("...changes? " & vbCrLf & VbCrLf & "CHOOSING ...

puts a blank line between ........changes? and CHOOSING.........


--
PC Datasheet
A Resource for Access, Excel and Word Applications
[email protected]
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel

Thanks Peter thats great!