ACC: List of New Report Events & Properties in Versions 95/97

• Microsoft Access versions 7.0, 97

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

This article lists the new events and properties for reports in Microsoft Access 7.0 and Microsoft Access 97.

MORE INFORMATION

Name               Applies To   Type       Description

Filter             Report       Property   Use this property to limit
                                           the report's recordset.

FilterOn           Report       Property   Use this property to determine
                                           whether the report's recordset
                                           is being filtered.

GrpKeepTogether    Report       Property   Use this property to specify
                                           whether the groups that have
                                           their KeepTogether property
                                           set to Whole Group or With First
                                           Detail will be kept together by
                                           page or by column.

HasContinued       GrpHdr       Property   Use this property to determine
                   PgHdr/Ftr               if the current section is
                   Detail                  continued from the previous
                                           page.

HasData            Report       Property   Use this property to determine
                                           if a form or report is bound
                                           to an empty recordset.

HasModule          Report       Property   Use this property to determine
                                           if a form or report has a class
                                           module.

InSelection        PgHdr/Ftr    Property   Determines if an object
                   GrpHdr/Ftr              is selected in Design view.
                   Detail

OnNoData           Report       Event      Use this property to cancel
                                           the report when there are no
                                           records.

OnPage             Report       Event      Occurs at the end of each page.
                                           Use this event with the Print,
                                           Line, and Circle methods to draw
                                           anywhere on the page.

OrderBy            Report       Property   This is a string expression that
                                           is the name of the field or
                                           fields on which you want to sort
                                           records.

OrderByOn          Report       Property   Use this property to Determine
                                           whether the report's recordset
                                           is being sorted.

Picture            Report       Property   Use this property to add a
                                           picture to a form or report.

PictureAlignment   Report       Property   Use this property to specify how
                                           a form or report's picture is
                                           aligned.

PicturePages       Report       Property   Use this property to specify on
                                           which page or pages of a report
                                           a picture will be displayed.

PictureSizeMode    Report       Property   Use this property to specify how
                                           a form or report's picture is
                                           sized.

PictureTiling      Report       Property   Use this property to specify
                                           whether a picture associated
                                           with a form or report is tiled
                                           across the entire form or
                                           report.

PictureType        Report       Property   Specifies whether a picture is
                                           stored as a linked object or an
                                           embedded object.

RepeatSection      GrpHdr       Property   Use this property to specify
                                           whether a group header is
                                           repeated on the next page or
                                           column when a group spans more
                                           than one page or column.

ShortcutMenuBar    Report       Property   Use this property to specify a
                                           custom shortcut menu for a
                                           report.

Toolbar            Report/      Property   Use to specify the toolbar to
                   Form                    use for a form or report.

WillContinue       PgHdr/Ftr    Property   Use this property to determine
                   GrpHdr/Ftr              when a section will continue
                   Detail                  on the next page.

REFERENCES