Automated print of Access 2002 report

[MrDenmark]

Hi

Im tring to automate printing of a report, but i ran into some difficulties. The report is made on a standard A4-paper format, but sometimes i have to change the output to A3-paper format.

I have figured out changing the paper format, the paper bin and the printer, but then the output only takes up half of the paper.¨

I have to enhance the content with 141 %, but how ???

This is what i have tried so far:

With accRep.Printer
    .PaperSize = acPRPSA3
    .ItemSizeHeight = .ItemSizeHeight * 1.41
    .ItemSizeWidth = .ItemSizeWidth * 1.41
End With

But it doesn't change a thing,,,

Anyone who can help ???

[Matt_T_hat]

Originally posted by MrDenmark
The report is made on a standard A4-paper format, but sometimes i have to change the output to A3-paper format.

if the report is sometimes a different size / shape is it maybe not the case that it is two report?

YMMV but I always try to keep reports in an A4 format and have the data run down the page(s)