acViewPreview (Acess2000-VBA)

Topic

New Reply

Another novice question from the dinosaur:

I would like to know how to have a report in acViewPreview mode open in the magnified view. My client does not want to have to use the mouse to click on the preview to get the image magnified.

TIA
ElDinosaurio

Reply | Quote

Replies

DoCmd.OpenReport “ReportName”, acPreview
DoCmd.RunCommand acCmdZoom150

When you put in the RunCommand you can choose your magnifcation….

hth,
Jack

Reply | Quote

Jack,

Thanks, I will try this this morning. I only want it to open at 100% so this should work well for me

ElD.

Reply | Quote

What Jack has replied will work as long as you use one of the allowable specified Zoom levels.

If you want to set the Zoom level to a custom percentage then you can use the following function:

‘ This function allows Report Custom Zoom level from 0% to 2500%
Function PreviewAndZoomReport(ReportName As String, ZoomCoeff As Integer)
On Error GoTo Err_PreviewAndZoomReport

If Not (ZoomCoeff >= 0 And ZoomCoeff <= 2500) Then

Reply | Quote

Ricky,

Thanks for the code. I will try Jack’s first as I only need a simple fix, but I am keeping your function for future use.

Thanks again

ElD-

Reply | Quote