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
--
Duane Hookom
MS Access MVP
--

"PC Datasheet" <no****@nospam.spam> wrote in message
news:iz******************@newsread3.news.atl.earth link.net...

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

[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" <du*********@NoSpamHotmail.com> wrote in message
news:eN*************@tk2msftngp13.phx.gbl...

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

"PC Datasheet" <no****@nospam.spam> wrote in message
news:iz******************@newsread3.news.atl.earth link.net...

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]

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

--
Duane Hookom
MS Access MVP
--

"PC Datasheet" <no****@nospam.spam> wrote in message
news:l2****************@newsread3.news.atl.earthli nk.net...

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" <du*********@NoSpamHotmail.com> wrote in message
news:eN*************@tk2msftngp13.phx.gbl...

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

"PC Datasheet" <no****@nospam.spam> wrote in message
news:iz******************@newsread3.news.atl.earth link.net...

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