new line

S

smk23

Is there a way to get a new line into the Control Source of a form control? I
know I can use vbCrLf in vba code, but I was hoping to code it directly in
the textbox control source.
 
R

Rick Brandt

smk23 said:
Is there a way to get a new line into the Control Source of a form
control? I know I can use vbCrLf in vba code, but I was hoping to
code it directly in the textbox control source.

="some text" & Chr(13) & Chr(10) & "some more text"
 
S

smk23

I'm getting a couple of boxes in my display where the Chr(13) and Chr(10) are.

some text | | some more text
 
D

Douglas J. Steele

You sure you've got Chr(13) & Chr(10) in that order: that you haven't
reversed them as Chr(10) & Chr(13)?
 
Top