You could try setting the Keep Together property of the section that
contains the memo field.
Setting it to No might allow Access to print whatever fits on the page. No
guarantee that it will break at a paragraph break (if that matters.)
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<ka************@gmail.comwrote in message
news:11**********************@d55g2000hsg.googlegr oups.com...
Hi everyone,
I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page breaks.
In other words, if my memo field is 3 paragraphs long and there
is only space on a report page for 2 paragraphs, rather than
putting 2 paragraphs on one page and the last one on the next
page, all 3 paragraphs are moved to the next page (which creates
a lot of wasted white space on the first page!). I assume
Access does this because it sees the entire memo field as a
'cell' that cannot be split up.
Does anyone have any idea how I can enable Access to split my
memo fields to conform with page lengths? Would using the Split
function work in this case?
Thank you in advance for your help!