- Count how many records fit on a page. No programming involved in this and it should be a constant value.
- Count the number of records you will be printing.
- As records are printed compare how many have been printed with how many will fit on a page.
- When you run out of records to print, stop Access from advancing to the next record until you reach the number that will fit on a page.
provided by Julian Robichaux at nsftools.com.