Best fit for report

[Duane8889]

Hello
I am using Access 2k and when I show my report it defaults to 100%. I have been able to maximize and minimize but what I would like to do is the best fit choice.

A friend gave me this code...

Private Sub Report_Activate()
    DoCmd.OpenReport "rptRotationOneDay", acPreview
    Reports("rptRotationOneDay").ZoomControl = 0
End Sub

but i get the error "You entered an expression that has an invalid reference to the property zoom control".

I wonder if there is some update or download that I am lacking.

He tells me its an undocumented feature of Access.

Duane

 

[lupins46]

Can't see a problem in the code statements but I'm doubtful about the event you using here. Are you trying to open one report from another?

 

[Duane8889]

thanks lupin
You are right. It needed to be in an event procedure. Now it works!

I was calling it from a form.