Automatically Scale/Zoom report

[Guest]

Hi. I would like that my report automatically zoom to 120% when is open.

Is it possible to make it zoom automatically?

Regards,
Marco

 

[Stefan Hoffmann]

hi Marco,

Hi. I would like that my report automatically zoom to 120% when is open.
Is it possible to make it zoom automatically?

Yes.

Reports("ReportName").ZoomControl = 120


mfG
--> stefan <--

 

[Guest]

Hi.

Do I put that when I press the button on the formt to print? or on load of
the report?

regards,
marco

 

[Stefan Hoffmann]

hi Marco,

Do I put that when I press the button on the formt to print? or on load of
the report?

You need to call it after the DoCmd.OpenReport in the button event.


mfG
--> stefan <--

 

[Marshall Barton]

Reports("ReportName").ZoomControl = 120

Do you have any information about why that property is not
in Help and is a hidden item in the Object browser?
Normally, the lack of documentation means there is some kind
of (last minute?) issue with the feature.

 

[Guest]

You can use sequence in the procedure that opens the report:

DoCmd.OpenReport . . .
DoCmd.RunCommand acCmdFitToWindow

Which is probably better for your needs than the limited
fixed zoom factors:
acCmdZoom10
acCmdZoom100
acCmdZoom1000
acCmdZoom150
acCmdZoom200
acCmdZoom25
acCmdZoom50
acCmdZoom500
acCmdZoom75

 

[Stefan Hoffmann]

hi Marsh,

Do you have any information about why that property is not
in Help and is a hidden item in the Object browser? No.

Normally, the lack of documentation means there is some kind
of (last minute?) issue with the feature.

This feature is - from my point of view - stable. I'm using it since
years or so.

I found on http://www.mvps.org/access/reports/rpt0020.htm

But you are right, using undocumented features need some caution, so use
it with an error handler.


mfG
--> stefan <--