Automatically Scale/Zoom report

M

Marco

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

Is it possible to make it zoom automatically?

Regards,
Marco
 
S

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?
Click to expand...
Yes.

Reports("ReportName").ZoomControl = 120


mfG
--> stefan <--
 
M

Marco

Hi.

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

regards,
marco
 
S

Stefan Hoffmann

hi Marco,
Do I put that when I press the button on the formt to print? or on load of
the report?
Click to expand...
You need to call it after the DoCmd.OpenReport in the button event.


mfG
--> stefan <--
 
M

Marshall Barton

Stefan said:
Reports("ReportName").ZoomControl = 120
Click to expand...


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.
 
C

Chris Reveille

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
 
S

Stefan Hoffmann

hi Marsh,

Marshall said:
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.
Click to expand...
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 <--
 
Top