If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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" wrote in message 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 |
#3
|
|||
|
|||
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" wrote in message ... 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" wrote in message 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 |
#4
|
|||
|
|||
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" wrote in message 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" wrote in message ... 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" wrote in message 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to select paragraph between tow specified words? | ALIOX | General Discussion | 1 | June 28th, 2005 08:56 AM |
Formulas dealing with text data | Bagia | Worksheet Functions | 6 | June 20th, 2005 10:29 PM |
Combo Box (1st) Populating Text Box (2nd) Field | AccessRookie | Using Forms | 1 | April 6th, 2005 11:37 PM |
Access reports with a horizontal line after each record??? | Bill via AccessMonster.com | Setting Up & Running Reports | 6 | March 9th, 2005 04:51 PM |
How does the "auto" setting work in Paragraph Spacing? | Joey | General Discussion | 9 | October 11th, 2004 08:44 PM |