How to print a Memo field in a Report

[Menglish]

How do you print a multi-lined memo field in a report form when an "Enter" key has been used in the memo field? All I can print is the first line.

I cannot find this in key searches or FAQ's.

Thanks for any help.

Millard

 

[ramani]

Hi
In your report form, select this Memofield box and make sure that you have selected.. Stretch with overflow
(Double Click on this box.. select this property)

If there are other items in the same report detail band.. select this property for all the items. ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[Mike Gagnon]

Menglish

Have you tried to copy the memo content to a variable and using the variable as the source instead of the actual memo?
Public gFile
Copy Memo comments to (m.gcFile)

An use "m.gcFile" as the source of the textbox of you report, an if its in the detail band set it to stretch with overflow.
Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Menglish]

Thanks Mike, that did it. I had thought about trying this, then go sidetracked and forgot. I tried setting the band to stretch but still only got the line up to the <Return> key was pressed. The method you suggested works perfect.

Thanks to you both,

Millard