Microsoft KB Archive/828409

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

Article ID: 828409

Article Last Modified on 4/16/2007

-

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.

Additional query words: ACC2003 previewed cut off truncated shortened

Keywords: kbsampledatabase kbreport kbprint kbprb KB828409

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.