Report won't print legal size

[Paul Fenton]

In an application we run, we have several reports that are supposed to
print legal size, landscape. Problem is that when we preview the
report, it's letter size and the use has to manually change it from
the File Print menu to Legal. When I created the reports, I formatted
them as legal size, but they still won't print that way

What am I missing here?


Paul Fenton

 

[Clifford Bass]

Hi Paul,

Same printer or different printer? If different, try fixing the page
setup on the user's machine and saving? Quit Access and restart. Try the
report again. Does it show/print correctly? If not, try specifying the
setup to be for that specific printer instead of the default printer. Again
save, quit, restart and see if it sticks.

Hopefully that will help,

Clifford Bass

 

[Paul Fenton]

Clifford, thanks for replying.

I should point out that this is an .mde application running on 10
workstations so they all have to have the same version. They print to
2 different printers and we get the same issue on both printers. Quit
and restart doesn't help.

I develop the application in an .mdb file here in my office, then
create the .mde file and deploy it to the client. Since his printers
are not installed here, I have to use the default printer in the
reports.

Any more ideas?


Paul Fenton

 

[Clifford Bass]

Hi Paul,

I have a legal, landscape report from work that I can test at home
tonight, see what happens.

A few questions: What version of Access are you using? Your client?
Are you setting the report to use a specific tray? Or to automatically
select the appropriate tray?

Clifford Bass

 

[Clifford Bass]

Hi Paul,

Sorry for the delay :-( Things came up. I did a test and was able to
replicate your issue. In one instance there was no problem and in the other
it printed to letter and then showed letter on the screen. I suspect the
reason for the problem is that different printers have different descriptions
for various paper sizes. Such as "Legal" vs. "Legal (8 1/2 X 14)", vs.
"Legal (8.5 x 14)", etc. Also, for the third test, Access did not even show
a paper size of legal as an option in one place. But did in another!
Technically I think they are supposed to use a standard code scheme beneath
the hood, so to speak. It also may have to do with the default settings for
the default printer.

So, what are you to do? Since you are providing an MDE instead of an
MDB, I assume you cannot have them make the printer setup change once and
save the change. Is that right? One thought is to install the drivers for
their printers on your computer, using their printer names. You should be
able to do this even though you do not have access to their printers. Then
do the setup for their printers. I will putter around a bit to see if there
is something that could be done in code.

Clifford Bass