43

Access Report Properties

A strong knowledge of report properties is very important to building robust reports in Access. As you probably know already, all the settings on a report and its controls are called properties. When building reports, you set many properties using the Access Property Sheet, which is the Access UI (user interface) tool that exposes most of the properties for many different objects in an Access database. This lesson discusses the basics of Access's report properties and how you can apply them in Access 2010.

LESSON SETUP

To begin working with report properties, you must have a report to work with in a database. Every report has the same properties, so it doesn't really matter what kind of report you use — except for Web Report objects, which are different and are for use with SharePoint Web Applications specifically. You can easily create a new report or just use an existing one that is already in a database — it doesn't really matter for the purpose of viewing the report's properties for this lesson.

THE PROPERTY SHEET PANE

As you've seen in previous lessons, the only method for working with report properties is the Property Sheet. Part of Access since the very beginning, the Property Sheet lists each of the properties that an object contains, providing a list of property names and their values. The pane consists of five tabs to help categorize each of the property types.

Opening the Property Sheet

You can open the Property Sheet pane in one of two ways: ...

Get Microsoft® Access® 2010 24-Hour Trainer now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.