Printing Problems - Access2003

[Hans-Juergen]

Hi

I have as similar problems Kristian Tylvad reported on 16.06.2005 with
reports.

Our reports are developed under access 2000 and worked on the target system
with office 2000 pretty fine. All Reports have set the Papersize to A4
(printer is the default printer). Now our customer migrates to Office 2003
(win2k). Opening our mdb in Access 2003 many (but not all) reports changed
their papersize to LETTER. (Contacting Microsoft we get the information,
that this Problen is a office 2000-matter, which they don't support any
longer. )

To make a workaround for this problem in access 2003, I set the
Printer.Papersize Attribute for all Report objects to A4. Anyway some
Reports still shows LETTER in opening the Page-Setup-Dialog.

Another problem appears when sending th reports to a TIFF-Printer (black
ice) . When setting the report to the default printer, one page will be
splitted to many tiff-files (with extra large characters). Setting the
report to the special printer (which is the same as the defaultprinter) one
page will be printed exactly into one tiff-file.

Does anyone has solution for this problem

regards

Hans-Juergen

 

[Chris Mills]

Printer settings can be reset if the printer PORT changes, which can lead to
Letter if it's the printer default.

I don't know when or if this long-standing issue has been fixed.

MS helpfull advice is "don't change the printer port".

If it does change, you have to have some way of setting the printer again
(such as design permission for the database).

(Printer Port refers to whether it is printing via, say, LPT1. If you have
networked printers, basically it could be any port)

Is there some way to set that printer to default to A4, perhaps even with
another printer-driver?

Chris

 

[Guest]

Is there some way to set that printer to default to A4, perhaps even with

another printer-driver?

I've never seen that problem EXCEPT on windows configured as
region=us, language= en-us. I may just be lucky, but my reports
have always reset to A4. What region and language are your PC
and print server set to?

(david)

 

[Chris Mills]

Not sure if question for me, anyone can answer! ;-)

I've never seen that problem EXCEPT on windows configured as
region=us, language= en-us. I may just be lucky, but my reports
have always reset to A4. What region and language are your PC
and print server set to?

I can't confirm that. Customer site quite a while ago. Quite rare, I believe I
confirmed their port nbr was different (and only 1 PC on the site, which
proves nothing). My app has a "Set Specific Printer" routine, otherwise I'd
have been stuck just with Runtime.

I DO like to point out to sites what country they live in. I mean, we're big
enough to make the drop-list <g> And usually I'm aware of that because my app
tests for European short-date format (which is not comprehensive of course).

But thankyou. I'll bear it in mind as those regional settings are quite likely
even here. I don't mind if only the US has problems <g>

Chris