Some data in the Products by Category Report is not visible when you view the report in print preview (828409)


The information in this article applies to:

  • Microsoft Office Access 2003
This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).

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

SYMPTOMS

In Microsoft Office Access 2003, when you view the Products by Category report in Print Preview in the Northwind.mdb sample database or the NorthwindCS.adp sample Access project, you may not be able to see all the data that is contained in the report. The data at the right end of the preview page is not visible.

CAUSE

This problem occurs because Access 2003 sets the page orientation to Portrait view.

WORKAROUND

To work around the problem, set the page orientation of the report to Landscape view. To do so, follow these steps:
  1. Start Access 2003.
  2. On the Help menu, point to Sample Databases, and then click Northwind Sample Database.
  3. In the Database window, under Objects, click Reports.
  4. In the right pane, click Products by Category.
  5. On the File menu, click Page Setup.
  6. In the Page Setup dialog box, click the Page tab.
  7. On the Page tab, click Landscape.
  8. Click OK.
You can now view the whole Product by Category report.

MORE INFORMATION

In Microsoft Access 2002, the Products by Category report is designed to fit in the Landscape page orientation. However, in Access 2003, the default page orientation is set to Portrait view. Therefore, you may see that the report is clipped at the right end of the preview page.

Steps to Reproduce the Problem

  1. Start Access 2003.
  2. On the Help menu, point to the Sample Databases, and then click Northwind Sample Database.
  3. In the database window, under the Objects section, click Reports.
  4. In the right pane, right-click Products by Category, and then click Print Preview.
The right side of the report is clipped on the preview page.
Modification Type:MinorLast Reviewed:6/3/2004
Keywords:kbsampledatabase kbReport kbprint kbprb KB828409 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.