Software

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.

3 comments
akuttym
akuttym

Required reply on how to create form in ms outlook 2007. some other blogs gave me some insturction but not enough because it was complicated and I tried that but not successful. If I get in step by step way would appreciated.

ProfTech
ProfTech

This works well except it forces a page break after the report header before the first group prints. I know the report header is often used as a cover sheet to an entire report so this may not really be a problem. By selecting "After Section" in the Group Footer, the page break follows the section instead of leading the section. Of course this then forces a page break before the report footer. Either place works well, just be sure you understand it affect the location of report header/footer.

toliver
toliver

How can I force a new page (like this article suggests) in Access 2007? Thanks!

Editor's Picks