Report Effect

Table 14.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 is used to evaluate the number of times the Format event has occurred for the current section of the report. The Format event occurs more than once whenever the Retreat event occurs. By checking the FormatCount property, you can ensure that complex code placed within the Format event is executed only once. 

PrintCount 

The PrintCount property is used to identify the number of times the Print event has occurred for the current section of the report. The Print event occurs more than once whenever the Retreat event occurs. By checking the value of the PrintCount property, you can ensure that logic within the Print event is executed only once. 

Private Sub Report_Activate()
    '  Used by Solutions to show toolbar that includes Show Me button.
    '  Hide built-in Print Preview toolbar.
    DoCmd.ShowToolbar "Print Preview", acToolbarNo
    '  Show Custom Print Preview toolbar.


    DoCmd.ShowToolbar "Custom Print Preview", acToolbarYes

End Sub