O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

11.5. Report Properties

There are many properties on a report you can use to add some interesting features to your reports. Let's look at a few of these properties and some scenarios for using them with VBA. You can find a more comprehensive list of properties for reports and sections in Appendix G.

11.5.1. Section Properties

As you might expect, the properties on the Section object include members such as CanGrow and CanShrink and formatting properties such as AlternateBackColor. They're interesting, but there are a few properties that are not available in the property sheet that you'll want to look at a little closer.

11.5.1.1. WillContinue

A section's WillContinue property indicates whether the section will break onto the next page. It's useful for displaying a string such as "Continued on the next page" in a label at the bottom of the page.

This property is not available to reports opened in Report view or Layout view.

11.5.1.2. HasContinued

The HasContinued property is the opposite of the WillContinue property. It indicates whether a section has continued from the previous page. This is useful for displaying a string such as "(continued)" in a section at the top of the page.

This property is not available to reports opened in Report view or Layout view.

11.5.1.3. ForceNewPage

The ForceNewPage property sets page breaks on a report. You can use it to force a page break after a group level to keep related data on a single page. A good example of this is invoices, where you ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required