Scale to Print on One Page

[diane802]

Is there a way similar to in Excel where you can set the Print Setup to "Scale to Fit" say 1 wide by however many pages needed?

[llkhoutx]

Shrink-to-fit using the "Page Setup" "Fit-to:" options.

[diane802]

i do not see that as an option on the Page Setup screen.

[llkhoutx]

It's there. Try the PrintPreview f the report, then the PageSetup icon.

[RuralGuy]

I do not see that option on my Page Setup form either. It may also be a feature of certain printer drivers.

[llkhoutx]

Sorry, IU was looking at Excel print preview.

A solution would be to cycle through all the reports and subreport controls proportionally reducing them in (twips) size ((Desided page width *1440) / (Real form width in inches * 1440)). Control height should probably also be adjusted. Lines probably don't require adjustment.

I'd try it on the report OnFormat that fires first; if that doesn't work try it on the design view of the report with a Class Module function.

[RuralGuy]

Sorry, IU was looking at Excel print preview.

A solution would be to cycle through all the reports and subreport controls proportionally reducing them in (twips) size ((Desided page width *1440) / (Real form width in inches * 1440)). Control height should probably also be adjusted. Lines probably don't require adjustment.

I'd try it on the report OnFormat that fires first; if that doesn't work try it on the design view of the report with a Class Module function.

That solution should keep the OP busy for a while.

[llkhoutx]

Rural Guy, I believe that you are incorrect. I've been around the block for a long, ling time. Modern CPUs never cease to amaze me.

I programmatically modify controls and their respecttive properties all the time and have never experienced a performance hit while doing so.

The compute time is insignificant.

[RuralGuy]

I believe I said "keep the OP busy", not the CPU.

[diane802]

so is my only real option to just format the sheet so it fits on one page?

[RuralGuy]

so is my only real option to just format the sheet so it fits on one page?

I believe so Diane.