ACC: How to Print a Conditional Page Header in a Report 1.x/2.0Last reviewed: June 3, 1997Article ID: Q105516 |
The information in this article applies to:
SUMMARYNovice: Requires knowledge of the user interface on single-user computers. This article describes how to print a conditional page header using an example that forces the page header (which contains the column header labels), to print on consecutive pages of the report if a data group spans more than one page. The technique described in this article works for Microsoft Access versions 1.x and 2.0. However, an alternative method for version 2.0 is described in the Solutions sample application. See the "References" section of this article for a complete reference to this method.
MORE INFORMATIONReports print group header information once per group, even if the group of data spans more than one page. In reports, a common layout is to place the grouping value in the group header along with the column labels. However, because this data is not repeated when a group spans more than one page, the column header labels are not repeated on the subsequent page(s). To create conditional headers, you must create a new page before each group of data and set a flag from the group header to determine when the page header should print. Then, from the group footer, set the flag back so that the page header does not print at the beginning of the next group. To create the conditional headers, follow these steps:
REFERENCESYou can find information, instructions, and examples in the Solutions sample application (SOLUTION.MDB) included with Microsoft Access version 2.0. For more information about printing a conditional page header, open the SOLUTION.MDB database usually located in the ACCESS\SAMPAPPS directory. Select "Control what you print on reports" in the Select A Category Of Examples box, then "Repeat a group name at the top of a column or page" in the Select An Example box. For more information about repeating group names, please see the following articles in the Microsoft Knowledge Base:
ARTICLE-ID: Q93927 TITLE : ACC: Repeating Group Name at Top of New Column or Page (2.0) |
Keywords : kbusage McrHowto RptEvent RptLayou
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |