Print Preview Report

[MadeCurler]

I have assigned a macro to a button that opens a report in print preview mode. When the report opens it is set at "Fit" in the tool bar and I have to zoom to 100% to see the data properly. Is there any way I can adjust the macro code or report properties to open the report at 100%

 

[PNGBill]

Does this help ? http://www.access-programmers.co.uk/forums/archive/index.php/t-26059.html

 

[MadeCurler]

Yes it does help...thanks so much.....the answers are all there but it's just knowing where to look (if you have the time) or who to ask (like you)...I spent ages on this forum and scouring VBA books but you gave me the answer while I was asleep!

This worked for me.

DoCmd.OpenReportetc
DoCmd.RunCommand acCmdZoom150

 

[PNGBill]

Don't forget to thank Google
The post was originally done in 2000 I think