Microsoft KB Archive/90870

= ACC: Page Header That Spans Full Width of Multi-Column Report =

Article ID: 90870

Article Last Modified on 5/9/2003

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q90870



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



SUMMARY
Requires knowledge of the user interface on single-user computers.

You can design a report in Microsoft Access that has a page header which spans the entire width of the page, a group section header that is the width of a column, and a multiple-column detail section.

To do this, you define the columns in the Page Setup dialog box (Print Setup box in Microsoft Access 2.0) as either Vertical (or snaking) or Horizontal. This article describes the steps to create a report with three, 2-inch wide snaking columns.

NOTE: Instructions for this technique in Microsoft Access for Windows 95 are in the Microsoft Access for Windows 95 Help menu. See the &quot;References&quot; section at the end of this article.

NOTE: This article explains a technique demonstrated in the sample files, RptSampl.exe (for Microsoft Access for Windows 95 version 7.0) and RptSmp97.exe (for Microsoft Access 97). For information about how to obtain these sample files, please see the following articles in the Microsoft Knowledge Base:

145777 ACC95: Microsoft Access Sample Reports Available in Download Center

175072 ACC97: Microsoft Access 97 Sample Reports Available in Download Center



MORE INFORMATION
In Microsoft Access 1.x and 2.0, to create a grouped, multiple-column report where the page header spans the width of the page, follow these steps:
 * 1) In report Design view, drag the right edge of any report section to the desired width of the report. For this example, drag the edge over to the 7 inch mark on the ruler.
 * 2) Choose Sorting and Grouping from the View menu and enter a field or expression in the Field/Expression box to group your data by.
 * 3) In the Group Properties section of the Sorting and Grouping dialog box, enter Yes for Group Header.
 * 4) Using the Toolbox, create a Label and place it in the page header. Enter the text for the label in the Caption property. Size the text box so that it is the same width as the page header.
 * 5) Using the Toolbox, add a text box bound to the group field. Position the text box in the group header. Size this control 2 inches wide or less, and place the left edge of the box along the left edge of the group section.
 * 6) In the detail section place your bound control(s) within the first 2 inches.
 * 7) From the File menu, choose Print Setup.
 * 8) In the Print Setup dialog box, choose the More button.
 * 9) In the Items Across box, type the number of columns you want in the detail section. For this example, enter 3. Leave row and column spacing as they are.
 * 10) In the Item Size section, clear the Same As Detail check box.
 * 11) In the Width box, type the number of inches you want to allow for each column of data. For this example, enter 2.
 * 12) Under Item Layout, select Vertical. This creates a snaking column report. Choose OK.
 * 13) Click the group header section to display the property sheet. For the NewRowOrCol property, choose Before Section. This causes the group header to be printed at the top of the column one time for each new group. Print or Preview the report.

