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

John Bodin jbodin at sbor.com
Thu Sep 22 10:06:22 CDT 2016


Run code to replace another field with "Line1" & vbCrLf & "Line2" and then insert that field onto your report.  Does that work?  And you can substitute chr(13) and Chr(10) for vbCrLf if you can't use that constant.






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 10:49 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How to Embed Line Feeds in a Single Field that Appears on a Report

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


More information about the AccessD mailing list