Print each group of your Access report on a separate page

Ensuring that your Access report groups print out on individual pages is just a matter of tweaking your group header property settings. Mary Ann Richardson shows how to do it.

You have a number of offices in various cities across the state. You need to send the latest employee information to each office. You have already grouped your Employees report by city. Now you want to be sure that when this report is printed, each city's employees list is printed on a separate page. Follow these steps:

  1. Open the report in Design view.
  2. Click on the group header button for City.

  1. In the GroupHeader's Property sheet, click the All tab.
  2. Click the Force New Page property box drop-down arrow and select Before Section.

Now each city's employees list will begin printing on a new page.

Miss an Access tip?

Check out the Microsoft Access archive and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.