msgbox

[george]

hello,
how can i display the content of the msgbox over 2 lines
or more instead of 1 single line.
exemple:
Clicking this buttom will cause data to be erased.
Do you want to proceed?

thanks for your cooperation in advance.

 

[PC Datasheet]

MsgBox "Clicking this buttom will cause data to be erased." & VbCrLf _
& "Do you want to proceed?"

Will give you this:
Clicking this buttom will cause data to be erased.
Do you want to proceed?

MsgBox "Clicking this buttom will cause data to be erased." & VbCrLf & VbCrLf _
& "Do you want to proceed?"


Will give you this:
Clicking this buttom will cause data to be erased.

Do you want to proceed?

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

 

[Denny G.]

MsgBox "Clicking this buttom will cause data to be
erased. " _
& "Do you want to proceed?"

Denny G.

 

[george]

thks jmonty, the vbCR did it.

-----Original Message-----
Msgbox("Clicking this buttom will cause data " & _
"to be erased." & vbCR & "Do you want " & _
"to proceed?", vbYesNo, "Title")

Sorry about the continuation characters(_) but space is
limited. Anyway Use the built in vbCR = Carriage Return.
Highlight it (vbCR) and press F1 for more info.


.