Report's text box control split by page break

[pemigh]

I have a report with pages breaking in the middle of text box controls.
And it's not just on a line-by-line basis, but sometimes (in a
situation that I can no longer recreate) just the bottom portions of a
line's letters were showing up at the top of a page.

My experiments show that Access will ordinarily break before a text box
if the whole thing won't fit, but I haven't been able to find a
property that will control this behavior.

I wonder if the problem could be related to the fact that I created the
report by saving the corresponding form as a report. And even if it
is, I want to know how to change the behavior.

Any ideas??

PE

[Allen Browne]

In general, Access works with keeping sections together, rather than text
boxes.

One way around this is to create some extra group header/footer sections.
For example, if you choose the primary key field in the sorting'n'grouping
box and in the lower pane of that dialog set Group Header to Yes and Group
Footer to Yes, then these sections will appear for every record (because the
primary key is different every record). This give you the equivalent of 3
detail sections, so you can move some of the controls into the group header,
some into the group footer, set Keep Together to Yes for the sections, and
Access will break the page to keep each of the sections together.

If necessary, you can repeat that, making another group header and footer on
the same field (next row in Sorting'n'Grouping box), to get 5 sections, and
again for 7, or 9 sections.

Converting the report from a form should not have any bearing on this issue.

--
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.

"pemigh" <pe****@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

I have a report with pages breaking in the middle of text box controls.
And it's not just on a line-by-line basis, but sometimes (in a
situation that I can no longer recreate) just the bottom portions of a
line's letters were showing up at the top of a page.

My experiments show that Access will ordinarily break before a text box
if the whole thing won't fit, but I haven't been able to find a
property that will control this behavior.

I wonder if the problem could be related to the fact that I created the
report by saving the corresponding form as a report. And even if it
is, I want to know how to change the behavior.