ACC: Converted 2.0 Report Has Slightly Different Margins

Last reviewed: May 8, 1997
Article ID: Q139385
The information in this article applies to:
  • Microsoft Access versions 2.0, 7.0, 97

SYMPTOMS

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

You may receive the following error message when you try to print or preview a Microsoft Access 7.0 or 97 report that has been converted from Microsoft Access version 2.0:

   Some data may not be displayed.
   There is not enough horizontal space on the page for the number of
   columns and spacing you specified.

If you expand the page to the maximum size (usually 8" x 10.5"), you won't see the error message. However the controls that touch the unprintable region are not printed, despite appearing in Print Preview.

CAUSE

The default unprintable region for the default printer is used in the conversion process to prevent an error. When you convert a Microsoft Access 2.0 report with some of the margins set to zero to Microsoft Access 7.0 or 97, the margins in Microsoft Access 7.0 or 97 are not set to zero. Instead, they are set to the minimum margin that is valid for the default printer.

RESOLUTION

The workaround is described in the solution part of the error message. You need to reduce the column width, the column spacing, or the number of columns until the addition of these plus the default margins is less than the width of your paper.

For example, if Microsoft Access defines the left margin at .263 inches and the right margin at .266 inches, then you have used:

   .263 + .266 = .529 inches of the total 8.5 inches.

If you then define the column width at 3.8 inches, the column spacing at .15 inches, and column count at 2, you are now under the 8.5-inches width limit.

   2 x 3.8 inches = 7.6 inches
   7.6 inches + .529 inches + .15 inches = 8.279 inches.

If all these components add up to less than the page width, you can print the report without an error.

STATUS

This behavior is by design to prevent the report from printing data in the unprintable region of the printer.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open Microsoft Access 7.0 or 97.

  2. On the Tools menu, point to Database Utilities, and then click Convert Database

  3. In the Database To Convert dialog box, click the 2.0 version of NWIND.MDB. By default, this file is installed to \Access\Sampapps folder.

  4. Click Convert.

  5. In the Convert Database dialog box, type NewNwind.mdb.

  6. Click Save.

  7. When the conversion is complete, on the File menu, click Open Database.

  8. In the Open dialog box, click NewNwind.mdb, and then click Open.

  9. Open the Customer Mailing Labels report in Design view.

  10. On the File menu, click Print Preview. Note that you receive the following error:

    Some data may not be displayed. There is not enough horizontal space on the page for the number of columns and spacing you specified.

  11. Click OK.

  12. In the Country Filter dialog box, click Cancel. Note that you are returned to the report in Design view.

  13. On the File menu, click Page Setup.

    NOTE: In Microsoft Access 2.0, the right and bottom margins are set at 0, but in Microsoft Access 7.0 and 97, the margins are set to the minimum allowable margin for the default printer (usually .2" to .26").

  14. Click the Layout tab in the Page Setup dialog box.

  15. Reduce the width of the Columns from 4" to 3.5".

  16. On the File menu, click Print Preview. Note that you will no longer receive the error when previewing or printing the report.

REFERENCES

For more information about changing page setup properties, search on the phrase "unprintable region report margins," and then view "How Do I Set margins, page orientation, and other page setup options," using the Microsoft Access 97 Help Index.


Keywords : CnvGnrl kberrmsg kbusage
Version : 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 8, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.