I am designing reports to be printed in the USA and in Italy. We (USA) use the standard paper size (Letter) 8 1/2 x 11. Italy uses A4.

Currently I design the report so it will print on either paper but the results are wasted margins, etc.

Is there a way to have the report shrink and expand automatically to fit the selected paper? Sort of like Excel has a "fit to on page".

I noticed with I printed to a PDF so I could email the report - when I printed from Adobe it would shrink or expand the report depending on the paper I picked. This is what I want to do from Access.

Thanks for our help.