[AccessD] How to Embed Line Feeds in a Single Field that Appears on a Report

[Paul Hartland]

Brad,

As John was saying have you tried vbCrLf when building the final field, for
example in your fields try this;

Field1 (Short text)   - enter 'Line 1'
Field2 (Long Text (Plain Text format)) - enter 'Line 2'
Field3 (Long Text (Rich Text format)) - enter 'Line 3'

So you end up with three fields, now create a query and select the three
fields in separate columns and in the fouth column build them altogether
something like below;

FinalBuild: Field1 & vbcrlf & Field2 & vbcrlf & Field3

Which should produce something like below;

Field1       Field2       Field3      FinalBuild
Line 1       Line 2       Line 3      Line 1
                                              Line 2
                                              Line 3

Paul

On 22 September 2016 at 15:49, Brad Marks <bradm at blackforestltd.com> wrote:

> For testing, I built a small Access application with one table.
>
> In this table, I added three fields;
> Short text
> Long Text (Plain Text format)
> Long Text (Rich Text format)
>
> I then added this data to each of the three fields in the table
>
> Line1 Chr$(13)  Chr$(10) Line2
>
> I then built a small report to display these three fields.
>
> Here is what I see on the report for each of the three fields -
>
> Line1 Chr$(13)  Chr$(10) Line2
>
>
> I was hoping to see this
>
> Line1
> Line2
>
>
>
>
>
> Brad
>
>
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Stuart McLachlan
> Sent: Thursday, September 22, 2016 9:21 AM
> To: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Subject: Re: [AccessD] How to Embed Line Feeds in a Single Field that
> Appears on a Report
>
> If vbCrLf doesn't work (it only works in VBA, not in queries), use
> Chr$(13) & Chr$(10) in its place.
>
>
>
> On 22 Sep 2016 at 14:08, John Bodin wrote:
>
> > Brad, if you put in vbCrLf's and Chr(9)'s when building your Single
> > Field, does the report strip them out?
> >
> >
> > So does "Hello" & vbCrLf & "World" & vbCrLf & "Hello" & chr(9) &
> > "World" produce
> >
> >
> > Hello
> >
> > World
> >
> > Hello   World
> >
> >
> > or simply
> >
> >
> > HelloWorldHelowWorld
> >
> >
> > John
> >
> >
> >
> >
> >
> > John Bodin
> >
> > sBOR Office Systems
> >
> > jbodin at sbor.com<mailto:jbodin at sbor.com>
> >
> >
> >
> >
> > ________________________________
> > From: AccessD <accessd-bounces at databaseadvisors.com> on behalf of Brad
> > Marks <bradm at blackforestltd.com> Sent: Thursday, September 22, 2016
> > 9:32 AM To: Access Developers discussion and problem solving Subject:
> > [AccessD] How to Embed Line Feeds in a Single Field that Appears on a
> > Report
> >
> > All,
> >
> > We have a rather complicated Access report (Shop Work Order).
> > Currently there is a single field near the top of this report that
> > displays information that is entered manually into our manufacturing
> > system.  Our users control how this information appears on the report
> > by entering the info with line breaks and tabs.
> >
> > This single field on the report is set up to "Grow" because the amount
> > of data can vary widely, from 0 lines up to maybe 20-30 lines.
> >
> > We are now changing our processing and the information that was
> > previously entered manually will now be coming from one or more
> > "detail" records in the manufacturing database.
> >
> > I am planning to combine the data from these detail records into a
> > single field (in a temporary table) which will be mapped to the field
> > on the report. So far, this works nicely, except for one issue.
> >
> > I am not sure how to embed "line feeds" and tabs in this one single
> > field when this field is being constructed from the detail records.
> >
> > Thanks,
> >
> > Brad Marks
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com