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

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.

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

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.

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.