report papersize changes when sent to different printer

[JohnMc]

A trusted report, used for many years, is now having problems printing when
sent to a different printer. The report was designed for an 8 x 11 paper,
fields are all within this and include standard margins. Nothing special or
unique about the report.

Normally, this report is always printing on our Epson DFX--9000 dot matrix
printer.
When the report is sent to the Xerox Workcenter Pro, the paper size changes
from fanfold 8x11 to that of Envelope No.10.

Why would this happen?

I had always designed my reports to be as generic as possible so that the
client can choose which printer they want. It would stand to reason that if
the report is designed for a standard 8x11 page, it should be able to print
on any printer.

I can print this page successfully on my old HP laserjet III, my clients
Lexmark's, the Expson, but not on the Xerox Workcentre Pro 232.

Xerox is remaining silent.

John.

 

[JohnMc]

Note:

name autocorrect is OFF;
tested with generic printer driver - same problem;
updated printer driver - same problem;
created new report, imported required fields, same problem;
defined report to Xerox printer (8x11) then sent it to Epson printer and it
reverts to the Fanfold 8x11. If the next report (invoice) is sent back to
the Xerox, it converts to the Envelope No.10 format.

seems to be a batttle between the Epson DFX-9000 and the Xerox Workcenter
Pro 232.

Can someone explain how Access interfaces with the printer drivers and WHO
decides what papersize to set and how do they do this.

JohnMc

 

[JohnMc]

Hello?

<pock> <pock>

is this mic on?

Could it be an ACCESS gremlin that has corrupted the MS Access software on
this particular workstation? Only two out of 8 workstations have this
problem.

Hello? Anyone?

 

[John Spencer]

Message read. However, I have never seen the problem and have no ideas on
how to solve it. AND that is probably true for the others that frequent
this forum.

Sorry.

Since it is limited to just two out of eight workstations, you might
double-check the references on those computers and you might also double
check (or triple check) that they have the same printer drivers as the
computers that do work. I would offer to test but I don't have the printers
you are using, so ...

Good luck

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[JohnMc]

Thank you John for the kind offer.

Yes, I've checked the reference levels and the update levels (actually the
network admin did this too) and it appears to be update and uniform on all
workstations. I wrote code to perform a snapshot of the report and it too
converts from letter format to Envelope No.10 (at least on our network
printers).

Since the two printers are networked, their drivers reside on the server and
are shared by all. Corrupt driver for one, corrupt for all.

In all my years I've never seen a standard report convert itself to the
Envelope No.10 format when redireced to another printer. Does not matter if
its HP laserjet to Canon injet....same problem on just those two workstations.

The only step I have not taken is to remove and reinstall MS Access 2003
from these two workstations.

Too bad I'm alone on this one...seems odd - statistically.

JohnMc

 

[Arctic77]

You are not alone John. I too am having trouble with a similar issue, but
instead of changing to no 10 envelope, it is legal size instead of letter.
hopefully someone can shed some light on this. The computer that is trying
to print the report is using the same printer/driver on a network with the
same default paper size.

R