Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources]

Alison Balter

نسخه متنی -صفحه : 544/ 173
نمايش فراداده

Special Report Properties

Several report properties are available only at runtime. They let you refine your report's processing significantly. These properties are covered in the sections that follow. The later section "Practical Applications of Report Events and Properties" provides examples of these properties.

MoveLayout

The MoveLayout property indicates to Access whether it should move to the next printing location on the page. By setting the property to False, the printing position is not advanced.

NextRecord

The NextRecord property specifies whether a section should advance to the next record. By setting this property to False, you suppress advancing to the next record.

PrintSection

The PrintSection property indicates whether the section is printed. By setting this property to False, you can suppress printing the section.

Interaction of MoveLayout, NextRecord, and PrintSection

By using the MoveLayout, NextRecord, and PrintSection properties in combination, you can determine exactly where, how, and whether data is printed. Table 10.1 illustrates this point.

Table 10.1. Interaction of MoveLayout, NextRecord, and PrintSection

MoveLayout

NextRecord

PrintSection

Effect

True

True

True

Move to the next position, get the next record, and print the data.

True

False

True

Move to the next position, remain on the same record, and print the data.

True

True

False

Move to the next position, get the next record, and don't print the data. This has the effect of skipping a record and leaving a blank space.

True

False

False

Move to the next position, remain on the same record, and don't print. This causes a blank space to appear without moving to the next record.

False

True

True

Remain in the same position, get the next record, and print the data. This has the effect of overlaying one record on another.

False

False

True

Not allowed.

False

True

False

Remain in the same position, get the next record, and refrain from printing. This has the effect of skipping a record without leaving a blank space.

False

False

False

Not allowed.

FormatCount

The FormatCount property evaluates the number of times the Format event has occurred for the report's current section. The Format event happens more than once whenever the Retreat event occurs. By checking the FormatCount property, you can make sure that complex code placed in the Format event is executed only once.

PrintCount

The PrintCount property identifies the number of times the Print event has occurred for the report's current section. The Print event happens more than once whenever the Retreat event occurs. By checking the value of the PrintCount property, you can make sure that logic in the Print event is executed only once.

HasContinued

The HasContinued property determines whether part of the current section is printed on a previous page. You can use this property to hide or show certain report controls (for example, Continued From…), depending on whether the section is continued.

WillContinue

The WillContinue property determines whether the current section continues on another page. You can use this property as you do the HasContinued property to hide or display certain controls when a section continues on another page.