How to add second, third page acording to some condition?

  • Thread starter Thread starter Min
  • Start date Start date
M

Min

Hi,I have put a table on the report body. The table will grow according to
some conditions therefore need to add second or even third page. I am
wondering how to do that. I don't need header or foot for other pages,
except the first page.
Thanks!
 
Min,

If you create your report with a report header (which will
only appear once at the start of the report) and
the "table" which I assume is the detail of your report
you can let access worry about subsequent pages. It will
roll onto the second page after the first is full and so
on.

HTH,

Terry
 
Thanks for reply!
The problem is on the second page, the header is still shown and the table
covers the header make the display disordered.
I only need the header shown on first page and the foot shown on last page.
But I failed to find how to set these properties. What I found is either no
header on every page or have header on every page.

Min
 
Hi,I have put a table on the report body. The table will grow according to
some conditions therefore need to add second or even third page. I am
wondering how to do that. I don't need header or foot for other pages,
except the first page.
Thanks!
Click to expand...

If you are taklking about the Page Header and Page Footer, then code
the Page Header Format Event:

Cancel = [Page] > 1

Do the same in the Page Footer Format event.
 
Min,
In design view of your report:
Under view you can turn on/off the page header / footer
and turn on/off the report header / footer. It sounds like
you want the Report header / footer ON and NOT the page
header / footer.

HTH,

Terry
 
Back
Top