Very Large Memo Fields 1

[dRahme]

Hello, I rarely use memo fields and inherited a table that contains a memo field. This memo field if set to Can Grow on a report will in some cases easily span the equivalent of two to three pages. It also locks up the report.

The report is set to print one record per page.

If I size the memo field to fit one page, the data is of course truncated and the report does print.

I am wondering what would be be best way to approach this. I don't think you can span one control over two pages but I may be wrong.

Would it be a better idea to split the memo field data into something more maneagable or is there another way to approach this?

Thanks,

 

[mkobulni]

My fix was to adjust the properties of the detail line of the report to a "No" for "Keep Together". Try that.

 

[dRahme]

That worked! Thank you. It looks like someone cut and pasted whole text documents into this field.

Thanks again, dRahme