Concatenate 3 lines of text into a "Paragraph"

[PC Datasheet]

I have three lines of text I need to concatenate into one "paragraph". The
"paragraph" need to look like:
Text1
Text2
Text3
where the lines of text are stacked in the "paragraph". When I use three
textboxes, there are definite breaks between Text1 and Text2 and Text2 and
Text3. I tried one textbox and set the control source to:
=Text1 & VbCrLf & Text2 & VbCrLf & Text3
but I get a dialog asking what is VbCrLf.

How can I concatenate the three lines of text and still keep the three lines
stacked?

Thanks,

Steve

 

[Duane Hookom]

vbCrLf is not recognized outside of a code module (VBA). You can use:
=Text1 & Chr(13) & Chr(10) & Text2 & Chr(13) & Chr(10) & Text3

 

[PC Datasheet]

Thanks, Duane!

Once upon a time I knew this but new information seems to have pushed out
old information. Does this ever happen to you?

Steve

 

[Duane Hookom]

Sometimes my old posts get quoted in newer posts and it makes me think "did
I say that?"