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?


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

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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print preview zoom 100 doesn't work 2
access report 0
Pause Between two reports 3
Previewing Reports 6
Print Previewing the Same Report 3
change report recordsource 1
Fit 2
Preview mode screen size 2

Back
Top