Fit To Window

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Re Access 97 (Golden Oldie)

Is it possible to force a report to "Fit To Window" when opened in preview?

I have tried;
DoCmd.RunCommand acCmdFitToWindow

in the Form's Activate event but Access reports this command is not
available at this time.

Can this be accomplished another way?

Many thanks.
 
Pete said:
Re Access 97 (Golden Oldie)

Is it possible to force a report to "Fit To Window" when opened in
preview?

I have tried;
DoCmd.RunCommand acCmdFitToWindow

in the Form's Activate event but Access reports this command is not
available at this time.

Can this be accomplished another way?

Many thanks.
Click to expand...

You have the correct statement, but for some reason you cannot use it from the
report's own code module. If the report is being opened via code (like pressing
a button on a form) then you can add that statement immediately after the
OpenReport line and it will work.
 
I am opening the report via a form button and your solution works perfectly!

Many thanks Rick.
 
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

report with query parameter and no data 3
Need docmd code to display multiple pages of report 3
Report Border - How do I draw one in VBA? 8
On No Data 2
How to maximize a report preview window and fit report from VBA? 9
Is it possible to have a button provide a users with more than 1 choice in access? 0
Automatically cycle thru pages in preview 2
Access How to prevent subReport from breaking across pages? 1

Back
Top