What is fit percentage and how does it work?

[davesaint86]

What is fit percentage and how does it work? I posted the below issue below my posted issue is a response I received.

Davesaint86 (Visitor) Mar 7, 2002
I added the code to each one of my command buttons on my menus to open my reports, print preview at 66%. My reports are opening up at 66% in the restore mode. The problem I'm having is that only about a third of the report appears on the screen. To view the report better you have to drag the borders or maximize each report. How can I get my reports to open up in the restore mode but with more of the report viewable?
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

JimAtTheFAA (MIS) Mar 7, 2002
The ZOOM percentage pertains to the relative size of the report. It's somewhat meaningless except in relation to other percentages - a 66% zoom will be about twice the size of a 33% Zoom, on a 17" tube at 1024x768. But take that same report to a 14" monitor at 640x480 and it will be different still.

A report opened at 66% in a MAXIMIZED window will be the same "size" as a report at 66% in a window 2 inches by 3 inches.

Have you tried the FIT percentage instead?



JimAtTheFAA (MIS) Mar 7, 2002
The ZOOM percentage pertains to the relative size of the report. It's somewhat meaningless except in relation to other percentages - a 66% zoom will be about twice the size of a 33% Zoom, on a 17" tube at 1024x768. But take that same report to a 14" monitor at 640x480 and it will be different still.

A report opened at 66% in a MAXIMIZED window will be the same "size" as a report at 66% in a window 2 inches by 3 inches.

Have you tried the FIT percentage instead?

 

[jfischer]

Fit percentage is the value "zero" for the ZoomControl property (mostly undocumented) of a report.

"Outside the report" you set unique values for the ZoomControl property. Open the report and then set the ZoomControl property. For example, in a form:

DoCmd.OpenReport "rptMyReport", acViewPreview
Reports("rptMyReport").ZoomControl = 0   'Zoom to Fit

"Inside the report" you control the size of the viewing window. You can use the OnActivate event to determine whether the report is in Preview mode. OnActivate only happens for Preview; it does not happen for direct printing. So, for example:

Dim PreviewModeYn As Boolean

Private Sub Report_Activate()
  PreviewModeYn = True
  DoCmd.Maximize
End Sub

Private Sub Report_Close()
  If PreviewModeYn = True Then
    DoCmd.Restore
  End If
End Sub