Microsoft Access 2010 Bible

Chapter 20: Advanced Access Report Techniques

737

To micro-adjust a control’s position, hold down the Ctrl key as you press the arrows keys. The

selected control will move in tiny increments in the direction indicated by the arrow keys you

press.

Adding Data

When you’re looking at data through forms, you can usually assume that the data is current.

However, with printed reports, you don’t always know if the data is old. Adding little touches like

when the report was printed can help increase the usefulness of a report. In this section, I show

you some techniques that will let you add additional information to the report to let the users

know something of its origin.

Adding more information to a report

You probably know that the following expression in an unbound text box prints the current page

and the number of pages contained in the report:

=“Page “ & [Page] & “ of “ & [Pages]

Both Page and Pages are report properties that are available at runtime and can be included on

the report.

But consider the value of adding other report properties on the report. Most of the report proper-

ties can be added to unbound text boxes as long as the property is enclosed in square brackets. For

the most part, these properties are only of value to you as the developer, but they may also be use-

ful to your users.

For example, the report’s Name, RecordSource, and other properties are easily added the same

way. Figure 20.29 demonstrates how unbound text boxes can deliver this information to a report

footer or some other place on the report.

FIGURE 20.29

rptMoreInfo demonstrates how to add more information to your reports.