Paragraphs in rich text memo field not showing in report

[peter2012]

I have an Access 2010 database with a memo field formatted for Rich Text.

I created a simple form. It accepts and shows paragraphs, i.e. I press Return and a new paragraph appears (with a blank line in between paragraphs).

I then created a report based on the same fields. In the memo field it shows the text entered in the form, but not the paragraph breaks. It just shows one big block of text without any paragraph breaks. I have looked for a field property in the report design and layout views that might affect how the text is displayed in the report but I cannot find one.

It is not much use if you can input paragraph breaks in a form but not see them in a report. I feel that there must be a way to do this but I cannot find an answer in this forum or anywhere else.

Simple solution anyone?

Peter

 

[pr2-eugin]

Peter, did you set the control of the Paragraph on the Report as Rich Text? Should that not sort your problem?

 

[peter2012]

Paul, where is that control set? I cannot see anywhere a way to set a control for a paragraph. Is it in Report/Design View or where please?

What I want to do is make one setting for the field which will cause it to show the paragraph breaks (which show in the equivalent form) in all of the items for that field showing in the report. Will your fix achieve that?

Thanks.

Peer