Force a New Page

Each customer should have their own letter. So, we need to Force a New Page. The Page Break will be added to the FullName Footer.

 

Before You Begin: Show the Footer

Go to Report Design Tools ->Design.

Go to Grouping and Totals ->Group & Sort.

 

In the Group, Sort and Total pane:

Select: Group on FullName.

Click on More.

Select: with a footer section.

 

What Do You See? There should be a new FullName Footer in the Report.

 

8. Try it: Force a New Page

Select the FullName Footer.

Go to Property Sheet->All.

Force New Page: After Section.

Exam 77-885: Microsoft Access 2010

5. Designing Reports

5.2. Apply Report Design options: Insert a Page Break

Report Design Tools ->Design-> Grouping and Totals ->Group & Sort