ACC1x: Report Wizard Defaults to 8.5-by-11-Inch Page

• Microsoft Access versions 1.0, 1.1

SYMPTOMS

When you use the ReportWizard to create a Groups/Totals report, if the Fit All Fields On One Page check box in the last ReportWizard dialog box is selected, the report controls are positioned in the leftmost 8.5 inches of the page. This happens even if you have changed the printer driver setup in the Microsoft Windows Control Panel to 8.5 by 14 inches with landscape orientation.

CAUSE

The default page settings are set by the ReportWizard and do not reflect the printer settings you make in the Control Panel.

RESOLUTION

In the report's Design view, modify the layout to reflect the page size you want. For example, you can extend the right edge of the report and place the controls in the newly extended area.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access versions 1.0 and 1.1. This problem no longer occurs in Microsoft Access version 2.0.

MORE INFORMATION

Steps to Reproduce Behavior

1. In the Microsoft Windows Control Panel, set your printer setup to 8.5 by 14, with landscape orientation.

2. Start Microsoft Access and open the sample database NWIND.MDB.

3. Create a new report based on the Employees table.

4. Choose ReportWizard and select Groups/Totals.

5. Add all of the fields to the report except the Photo field.

6. After building the report, select the Fit All Fields On One Page check box.

7. Preview the report.