new page

[Rodas1]

I am writing a data base that prints reports. I wonder if any body knows how can I force a new page every time I have 20 records I also need to reprint the headrer in every page.

 

[dhookom]

Reprinting the header is as simple as placing your header controls on a page header. You can set the heights of various sections so that only 20 records fit on each page.

You can also add a page break control at the bottom of each detail section and set up controls and code to make the page break invisible on all but every 20th row.

Duane
MS Access MVP