Automatically Scale/Zoom report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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

regards,
marco
 
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 <--
 
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.
 
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
 
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 <--
 
Back
Top