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?"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text parsing help needed 9
Set the Height/Width of a Text Box 1
Concatenate text from columns 1
Collating text files 3
If calculation in text box > 1 hour set check box = True 2
How to copy files and get file name 3
Next month 4
How to extract text from middle of a string 18

Back
Top