Access memo field to RTF - paragraph broken into lines RRS feed

  • Question

  • I have a text box on an Access 2010 report. The text box is based on a field in a DAO recordset. I loop through the recordset and update the field with concatenations of other string fields in the record.  I separate concatenated strings with vbCrLf to form paragraphs.

    Field3 = .Fields("field1") & vbCrLf & .Fields("field2")

    So the resulting text box on the report contains data formatted as paragraphs.  However, when I export to RTF, in the Word document, each paragraph ends up being broken up into individual lines. 

    The text format property of the text box on the report is defined as Plain Text.  If I change the property setting to Rich Text, I lose the paragraphs and the concatenated strings just run into one long string.  Changing the embedded vbCrLf control codes into CHR(13)/CHR(10) doesn't resolve that.

    How can I get Word to maintain paragraphs?


    Sunday, May 22, 2016 2:07 AM


All replies