Setting Paper Size In Code

[Tim J]

Is it possible to set the paper size and/or orientation
in code based on the number of records in a report?

 

[Allen Browne]

This is very messy. Different printers support different paper size options,
so you are manipulating the PrtMip in report design view to get the result.
That means it still won't work if you use MDE or runtime.

Best place to start would be this article:
http://www.microsoft.com/AccessDev/Articles/GetzCh10.HTM