Concatenate 3 lines of text into a "Paragraph"

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

re: Concatenate 3 lines of text into a "Paragraph"

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" <nospam@nospam.spam> wrote in message
news:iz5Ve.11121$FW1.9524@newsread3.news.atl.earth link.net...[color=blue]
>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
>[/color]

re: Concatenate 3 lines of text into a "Paragraph"

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" <duanehookom@NoSpamHotmail.com> wrote in message
news:eNWP2E0tFHA.908@tk2msftngp13.phx.gbl...[color=blue]
> 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" <nospam@nospam.spam> wrote in message
> news:iz5Ve.11121$FW1.9524@newsread3.news.atl.earth link.net...[color=green]
>>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
>>[/color]
>
>[/color]

re: Concatenate 3 lines of text into a "Paragraph"

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" <nospam@nospam.spam> wrote in message
news:l29Ve.11198$FW1.32@newsread3.news.atl.earthli nk.net...[color=blue]
> 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" <duanehookom@NoSpamHotmail.com> wrote in message
> news:eNWP2E0tFHA.908@tk2msftngp13.phx.gbl...[color=green]
>> 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" <nospam@nospam.spam> wrote in message
>> news:iz5Ve.11121$FW1.9524@newsread3.news.atl.earth link.net...[color=darkred]
>>>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
>>>[/color]
>>
>>[/color]
>
>[/color]