Table of contents
TOC
Collapse the table of content
Expand the table of content

Section.ForceNewPage Property (Access)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

You can use the ForceNewPage property to specify whether form sections detail, footer) or report sections (header, detail, footer) print on a separate page, rather than on the current page. Read/write Byte.

Syntax

expression. ForceNewPage

expression A variable that represents a Section object.

Remarks

For example, you may have designed the last page of a report as an order form. If the report footer's ForceNewPage property is set to Before Section, the order form is always printed on a new page.

Note The ForceNewPage property does not apply to page headers or page footers.

The ForceNewPage property uses the following settings.

SettingVisual BasicDescription
None0(Default) The current section (the section for which you're setting the property) is printed on the current page.
Before Section1The current section is printed at the top of a new page.
After Section2The section immediately following the current section is printed at the top of a new page.
Before &; After3The current section is printed at the top of a new page, and the next section is printed at the top of a new page.

Here are some examples of the ForceNewPage property setting.

SectionSample settingDescription
A group header displaying the yearBefore SectionThe group header is printed at the top of the page, followed by the detail section, group footer, and page footer.
A report detail sectionAfter SectionThe group footer is printed at the top of a new page.
A report header containing the report title and company logo.After SectionThe report title and logo are printed on a separate page at the beginning of the report.

Example

The following example returns the ForceNewPage property setting for the detail section of the Sales By Date report and assigns it to the intGetVal variable.

Dim intGetVal As Integer 
intGetVal = Reports![Sales By Year].Section(acDetail).ForceNewPage

See also

Concepts

Section Object

© 2018 Microsoft