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

[John Bodin]

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