Try placing each subreport into a section of its own instead of all 3 in the
Detail section.
In the Sortin'and'grouping box (View menu), choose the Primary Key field. In
the lower pane of the dialog, choose Yes for group header and group footer.
This gives you 2 more sections that repeat for every record (each primary
key value).
Do that again on the next row of the Sorting And Grouping dialog to get
another group footer for your 3rd subreport.
Place each subreport in its own section.
That should make it easier for Access to calculate whether the entire
subreport can fit onto the page before it has to figure out whether the next
one will fit as well.
--
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.
"Michael S. Montoya" <bl***@blank.com> wrote in message
news:2e*****************@newssvr14.news.prodigy.co m...
I have a report which has 3 sub-reports in the detail section. Everything
(subforms, detail section) is set to Can Grow and Can Shrink as True.
I have one record in which one of the subforms has about 7 detail items
and
the other subforms have several detail items. When I try and print this
record it does not get past "Formating - Hit Control-Break" in the status
line. When I delete a couple of the 7 line items, it prints fine. Is
there
something else besides the "can grow" that I am missing? It is as if it
doens't want the report to go to two pages and "hangs up".