Creating carriage returns in msg or input boxes

M

Michael

Hi! I was wondering how we create hard returns within an
input box to control the layout in the window.

Thanks for your help!!

Michael
 
B

Bob Phillips

vbCrLf

and you can also use Space(integer) to layout it out better.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
R

Robin Hammond

Greg,

I've written so many message boxes that I do the following to save some time
and effort.

public const L2 = vbcrlf & vbcrlf 'in the top of a general module
public const MT= "What I want on the top of message boxes"

'time saved writing this
call msgbox("This is line 1" & l2 & "this is line 2" & l2 & "this is line
3", vbokonly, mt)

'rather than this
call msgbox("This is line 1" & vbcrlf & vbcrlf & "this is line 2" & vbcrlf &
vbcrlf & "this is line 3", vbokonly, "What I want on the top of message
boxes")

Robin Hammond
www.enhanceddatasystems.com
 
Top