Concatenate 3 lines of text into a "Paragraph"

  • Thread starter Thread starter PC Datasheet
  • Start date Start date
P

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
 
vbCrLf is not recognized outside of a code module (VBA). You can use:
=Text1 & Chr(13) & Chr(10) & Text2 & Chr(13) & Chr(10) & Text3
 
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
 
Sometimes my old posts get quoted in newer posts and it makes me think "did
I say that?"
 
Back
Top