Force new Report for every 9 records

[dafyddg]

Hi,

Is there anyway that you can force Access to print another report every 9 records?

I have page header, invoice id header and a detail section with associated footers at the bottom too.

For every 9 elements in the detail section i want to print the invoice id header section again. I can't see anything in the properties that would let me do that, is there a way?

 

[lupins46]

Size the footer to take up the space?

 

[dhookom]

Add a text box in the detail section:
Name: txtRunCount
Control Source: =1
Add a page break control at the bottom of the detail section
Name: pgbrk
In the On Format event of the detail section, add this code:

   Me.pgbrk.Visible = Me.txtRunCount mod 9 = 0

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[dafyddg]

Cheers for that dhookom, seems to work fine