From Fit to 100%

  • Thread starter Thread starter elli
  • Start date Start date
E

elli

I know that this has been asked and answered before, but can't tind the
topic.... Openig a report it's size is Fit. What to do so they would open at
100% allways?

thanks, if anyone...

-elli-
 
elli said:
I know that this has been asked and answered before, but can't tind
the topic.... Openig a report it's size is Fit. What to do so they
would open at 100% allways?

thanks, if anyone...

-elli-
Click to expand...

Hmm, my experience is the exact opposite. Reports open to 100% by default and I
have to use code to make them open to Fit.

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdFitToWindow

If your situation really is the opposite you would need...

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdZoom100

AFAIK there is no way to make this happen when you are not opening the report
with code or a macro.
 
elli said:
Shoud we change our Accessess or computers then???;))
Click to expand...

What is the problem exactly? All you have to do is click on the report and it
toggles between fit and 100%.
 
Yes I know that it is not very big of a problem, but when reading reports
most of the day, remowing every 'unwanted'click, lessens the clicks by
hunreds a day, so why not, if its's possible....
Unless one is very keen on clicking....

-elli-
 
elli said:
Yes I know that it is not very big of a problem, but when reading
reports most of the day, remowing every 'unwanted'click, lessens the
clicks by hunreds a day, so why not, if its's possible....
Unless one is very keen on clicking....
Click to expand...

Well all you need is a form with a ListBox listing all of the reports and a
button that opens the selected report using the two lines of code I gave you.
For those users who *really* need a particular zoom level you just tell them to
use the form instead of just opening them from the db window.

With a form like that you could even let the user choose the zoom level they
want from another ListBox (of those supported).
 
.... And you can put that second line inside the
open event of the report, so it works where-ever
the report is opened from.

I find that reports open as 100% if windowed, and
if the database window and forms are maximised, the
reports open "To Fit".

(david)
 
david epsom dot com dot au said:
... And you can put that second line inside the
open event of the report, so it works where-ever
the report is opened from.
Click to expand...

Is that something the newer versions support? I have never been able to get the
window or zoom commands to work in any Report event.
I find that reports open as 100% if windowed, and
if the database window and forms are maximised, the
reports open "To Fit".
Click to expand...

I put DoCmd.Maximize in the Open event of all reports and they still open to
100% by default. Again this behavior could be different in newer versions.
 
Back
Top