Report needs to come up in FIT

  • Thread starter Thread starter DellaCroce
  • Start date Start date
D

DellaCroce

I am displaying a report using DoCmd.OpenReport "r_Report384",
acViewPreview. I want it to come up in the preview screen in FIT not 100%.
Can someone tell me what the property is and where I can set it?

Thanks
Greg
 
DellaCroce said:
I am displaying a report using DoCmd.OpenReport "r_Report384",
acViewPreview. I want it to come up in the preview screen in FIT not 100%.
Can someone tell me what the property is and where I can set it?
Click to expand...


Add this line of code immediately after the OpenReport line:

DoCmd.RunCommand acCmdSizeToFit
 
I am displaying a report using DoCmd.OpenReport "r_Report384",
acViewPreview. I want it to come up in the preview screen in FIT not 100%.
Can someone tell me what the property is and where I can set it?

Thanks
Greg
Click to expand...

Add a line of code:
DoCmd.OpenReport "r_Report384", acViewPreview
DoCmd.RunCommand acCmdFitToWindow
 
fredg said:
Add a line of code:
DoCmd.OpenReport "r_Report384", acViewPreview
DoCmd.RunCommand acCmdFitToWindow
Click to expand...


Whoops, I used the wrong constant. Glad you posted the
right one Fred.
 
Back
Top