put a break in the report based on sections

It works now.

Many thanks to you Marsh for being very helpful.

"Marshall Barton" wrote:

Associates wrote:
That works now . Thank you for your assistance and patience.

However, there is still one thing that bothers me. This report will show a
summary of how much we invoice our client at the end of a month. On the main
report, this is what it looks like.

I have something like columns headings as below in the "=Extra Detail" Header.

Items Description Period Previous billed Current bill

then - in here, i put the sub-report 1 here

followed by - in here, i put here the sub-report 2

Then, finally followed by "Detail" section with the rest of information goes
to the main report.

The problem i am facing here is that when it is all fit on one page (all
entries from sub-report 1, sub-report 2 and the rest of information in
"Detail" section), it looks fine but when I have more than one page, I start
to lose that columns heading. Then, i thought of another way of doing this. I
tried to move the whole heading to the "Page Header". Now, this time, it
appear on every pages of the report. However, it will look a bit ugly when it
is just enough to accommodate all the entries from both sub-report 1 and
sub-report 2 but the rest of the information will need to be on the next
page. This will of course make the heading appear there on the second page,
along with the rest of information in the Detail section. This looks a bit
strange. I hope i have not yet lost you so far. My question is whether there
is a way i can control the appearance of the columns heading. Is this
possible to do?


To turn off (make invisible) the main report's page header
after the second subreport is finished, add a line of code
to the second subreport's report footer section's Print
event:

Parent.Section(3).Visible = False

If the second subreport does not have a report footer
section, add it (View menu) and make its Height 0

--
Marsh
MVP [MS Access]