469,906 Members | 2,206 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,906 developers. It's quick & easy.

Report's text box control split by page break

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

Nov 13 '05 #1
1 6246
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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Robert Bowen | last post: by
6 posts views Thread by noway | last post: by
6 posts views Thread by vickie | last post: by
reply views Thread by kamboj.shalabh | last post: by
4 posts views Thread by D.Stone | last post: by
4 posts views Thread by lupo666 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.