Creating multiple-page reports in Access (new page for each group)

Question

I'm looking to create a report which is specifically designed to be over multiple pages, based on one condition. The condition is that when the grouped item (call it invoice) changes, it starts a new page, instead of putting all the data on as little pages as possible.

At the moment it runs like this,

Invoice, Date, ID
------------------
2      , Now , 1
------------------
3      , Now , 1
------------------

I want to insert a page break between the invoice numbers, but can't figure how to do it, is it possible?

Gord Thompson Gord Thompson · Accepted Answer · 2013-12-07T14:22:52

In the Group Header for "Invoice" on your report you can set the Force New Page property to Before Section to start each invoice on a new page. For details, see

Print each group of your Access report on a separate page

Creating multiple-page reports in Access (new page for each group)

1 Answers