Mysterious margins error

  • Thread starter Thread starter Zachariah
  • Start date Start date
Z

Zachariah

When a user tries to run a report, they get the following
message:

"The sum of the top margin, the bottom margin, the height
of the page header, and the height of the page footer is
greater than the length of the page you are printing on."

I found out that this is ErrorCode 2157 but I can't find
out any other information. I can preview and print the
report just find and none of the margin sizes mentioned
are anywhere near exceeding the page length (legal size
paper).

Has anyone else run into / resolved this? Thanks in
advance.
 
Zachariah said:
When a user tries to run a report, they get the following
message:

"The sum of the top margin, the bottom margin, the height
of the page header, and the height of the page footer is
greater than the length of the page you are printing on."

I found out that this is ErrorCode 2157 but I can't find
out any other information. I can preview and print the
report just find and none of the margin sizes mentioned
are anywhere near exceeding the page length (legal size
paper).

Has anyone else run into / resolved this? Thanks in
advance.
Click to expand...

Access will not exceed the margin limitations as defined by the printer
driver. You might have a printer driver that supports smaller margins than
the user experiencing the error.

Anyway, the error is not saying that the margins are exceeding the page
length. It is saying that the margins *combined with the content of the
report* is doing so.

For example, if you have all margins set to one half inch and your report
"just fits" on the page then a user with a printer that will only support a
6/10 inch bottom margin will not be able to fit your report on the page
since his bottom margin is larger.
 
Zachariah said:
When a user tries to run a report, they get the following
message:

"The sum of the top margin, the bottom margin, the height
of the page header, and the height of the page footer is
greater than the length of the page you are printing on."

I found out that this is ErrorCode 2157 but I can't find
out any other information. I can preview and print the
report just find and none of the margin sizes mentioned
are anywhere near exceeding the page length (legal size
paper).

Has anyone else run into / resolved this? Thanks in
advance.
Click to expand...

I haven't figured out a fix yet but I can tell you that the error is due to your page set up.

We have access on the server and we have four templates. I get this error with one out of four
of the templates, but none of my colleagues, using the same database and controls and templates,
get the error. They are all running smoothly, so it is something within my single PC environment.

I've tried resetting margins on my printers, and print to pdf, but have not found the set up that Access
seems to utilise when it sets the page with the template. I'll let you know if I figure it out.

(It's not a conflict either. Shut down all programmes bar Access and still got the same error).

Rachel
 
Back
Top