Fit to Window

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

Could I have the report to open in the "fit to window"?
Anyone know how to write a command on report open?

Thanks
 
Could I have the report to open in the "fit to window"?
Anyone know how to write a command on report open?

Thanks
Click to expand...

If you open the report from an event on a form, use:

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdFitToWindow
 
-----Original Message-----


If you open the report from an event on a form, use:

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdFitToWindow
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
I got Run-Time Error '2046':
Click to expand...
This command or action 'FitToWindow' isn't available now.

How can I fit this error?
 
This command or action 'FitToWindow' isn't available now.

How can I fit this error?
Click to expand...

I don't know?
Where did you place it?
It belongs in a Form's Command button click event.
(The button you click to open the report in preview.)
 
You must log in or register to reply here.

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

How to maximize a report preview window and fit report from VBA? 9
Access 2003 - Printing - Fit to Page 3
Epson XP-3150 not printing 2
Fit To Window 2
News Fitness apps can be used to track down names and addresses of users 2
Open report in Fit to window view 2
Default Report Screen Size 2
Is it possible to have a button provide a users with more than 1 choice in access? 0

Back
Top