Memo fields on a Report

  • Thread starter Thread starter Rotata
  • Start date Start date
R

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!
 
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
'====================================================
 
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,
 
Back
Top