Access memo field to RTF - paragraph broken into lines

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?

Thanks.

Answer 1

Hi. For RTF, try replacing vbCrLf with "<br />". Hope it helps...

Answer 2

Hi District9,

did the suggestion given by the DB guy worked for you?

you can also try to take all the paragraphs as a single text and then using split function you can separate in paragraph.

Regards

Deepak 

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.