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

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!
 
T

Terry

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
 
M

Min

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
 
F

fredg

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!

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

Terry

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top