Discussion Locked

Page Break in Access Reports

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have not been able to successfully create a page break on a certain field in my Access Database. Does anyone have simple directions on how to do this?

4 replies

by dryflies

page breaks in reports are set in the properties for a group. for example when preparing rosters for our baseball league, I group on division and Team. (Where a division has one or more teams.)I put a page break before each team. to do that you put the report into design mode, right click on the header bar for the group that you want to force the page break and in the format tab the first entry is "Force new page" the choices are before, after, before and after, and none

by dirtycar74

In the Properties for a Section (double click on a blank area of a section in design mode),
Force New Page:
Set this property to "Before Section" to force the section to print at the top of a new page. Set this property to "After Section" to force the next section to print at the top of a new page.

You can also insert a page break by selecting the icon in the (Standard) Toolbox (hover your mouse over the toolbox items until you find "Page Break" in the tooltips) and then clicking in the desired location in the design layout where you want it (the page break) to be. Bear in mind that this method cannot force breaks in certain sections, such as the headers or footers (but then again, who would want to do that?)

I hope this helps.

by ayuknotna

Add a page break to a report

In reports, you use a page break control to mark where you want to start a new page within a section. For example, if you want a report's title page and introductory message printed on separate pages, place a page break in the report header after the controls that you want to appear on the title page and before the controls for the second page.

1 Open the report in Design view.
2 Click the Page Break tool in the toolbox.
3 Click the report where you want to place the page break. Place the page break above or below a control to avoid splitting data in that control.

Microsoft Access marks the page break with a short dotted line on the left edge of the report.

If you want each group or record in a report to start on a new page, set the ForceNewPage property of the group header, group footer, or detail section.

NOTE: got this by pressing F1 while using Access.

This discussion is closed to new replies.