Memo fields on a Report

[Rotata]

Help,

Using Access 2007.

I am creating a report that includes several formatted memo fields. The size
of the data in any given field varies according to the record. When I print
the report, some of the memo fields get cut - part on one page, part on the
next. It makes for an awkward read. A single record can be six or seven
pages, or as few as two.

How can I make the report keep a memo field whole on one page, the way one
does with orphan/widow control in a paragraph in Word? Or, the way you adjust
page breaks in Excel?

Thanks!

 

[John Spencer]

I believe that each section in a report has a Keep together property.
Have you tried setting that to Yes?

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Rotata]

I tried both yes and no on the detail property and received the same results.

I think I need to be able to tell the individual fields not to separate, but
could not find a tick mark for that.

Do you have an example of some code I can use? I can't write VBA from
scratch, but I can usually tinker around with it until it works for me.

Thanks,