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

[Brad Marks]

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