Reports

[Joe675]

The current default when I open a report is set to "Fit." I would like to set the default to 85% which is not listed as one of the option sizes. I, of course, can change it to 85% after I have opened the report, but I would like 85% to be the default. Does anyone know how to do that? Thanks.

 

[ListO]

You probably already know this, but in case you don't...

You can use the following to open a report in one of the zoom sizes which are in the combo-box, but I don't know how you'd specify a choice which would normally have to be typed into that box. This example would open a report at 75%.

DoCmd.OpenReport "reportname", acViewPreview
DoCmd.RunCommand acCmdZoom75

 

[Joe675]

No, I didn't know that. Thank you. Not sure what you mean by combo-box though, and where to find it. I am pretty new at this. Thanks.

 

[ListO]

The combo-box to which I was referring is the one at the top of the Access print-preview page, which has a list of choices for zoom size. The standard zoom sizes of 200, 150, 100, 75, 50, 25, 10 and Fit, are the only ones which I know how to call with the above code.

I, too, would like to know how to specify a zoom setting other than those.

Good luck.

 

[Joe675]

Thanks again!