Memo fields on a Report




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?


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


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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question