ACC2000: Converted Access 2.0 Report Has Slightly Different Margins (208692)
The information in this article applies to:
This article was previously published under Q208692 Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
SYMPTOMS
You may receive the following error message when you try to print or
preview a Microsoft Access report that has been converted from 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-by-10.5-inches), you
won't see the error message. However the controls that touch the
nonprintable region are not printed, despite appearing in Print Preview.
CAUSE
The default nonprintable region for the default printer is used in the
conversion process to prevent an error. When you convert an Access 2.0 report that has some of the margins set to zero, the margins in Access 2000 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
should 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 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 nonprintable region of the printer.
REFERENCES
For more information about changing page setup properties, click Microsoft Access Help on the Help menu, type "How Do I Set margins, page orientation, and other page setup options" in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Major | Last Reviewed: | 6/29/2004 |
---|
Keywords: | kbbug kberrmsg kbfix KB208692 |
---|
|