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.9. Report View

As mentioned at the beginning of this chapter, Access 2007 introduces a new interactive view for reports called Report view. It is the default view for new reports created in Access 2007 and gives you much of the same functionality that you've enjoyed with forms, including the capability to search, sort and filter, and even copy! Let's look at some ways you can use all that new functionality.

11.9.1. Considerations When Designing for Report View

Before you start switching all of your existing reports to use Report view, there are a few things to consider. The following sections explore those factors.

11.9.1.1. Where Are All My Pages?

The first thing you'll notice about Report view is that there aren't any pages. A report open in Report view is really one big page that you scroll like a continuous form. Because of this, calculations that depend on the Page or Pages properties of the report may return unexpected results.

11.9.1.2. Events

As mentioned earlier, the Format and Print events don't fire in Report view. That's because those events are used with individual sections as a report is printed.

Because reports opened in Report view are not printed, there is a new Paint event to use with sections in Report view. As you learned earlier in the "Paint Event" section, Paint fires multiple times for a single section because of the way that controls are drawn on reports. When a section is being painted, it is too late to hide it, so you cannot dynamically hide sections ...

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