Changing zoom size default

[Steve S]

I have an db developed in A2000 with about 40 reports. ALL reports open 100%
in print/preview on machines running A2000 and XP w/all service packs.

when I distribute the front end (user interface) to a station running A2003
all reports open as "Fit" and the users have to zoom to make them readable.
The linked data tables reside on the A2000 station.

I did a search of past posts to this newsgroup and it seems the solution is
to put code in EVERY report. I hope someone has since figured out a better
solution.

Was the default for A2000 100% and the default for A2003 "Fit" or is there
really a way to change the default and I just can't find it?

 

[Al Campagna]

Steve,
This sounds likeyou have the AutoResize for the report set to YES. With
Auto Resize set to NO, the report should open in 100% mode.
But, I would not expect the reports on the 2003 PCs to be any different
than the reports on the 2000 PCs, so that really doesn't make sense. But,
what the heck... worth a mention.

Otherwise, I'm afraid you'll have to code to "force" the reports into
100% mode.
DoCmd.OpenReport "MyReport"
DoCmd.RunCommand acCmdZoom100
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Steve S]

thanks Al,

Your reply did not solve my problem but while testing I found that A2000
does not have a report property 'Auto Resize'. At least on the version I
have. I can't get access to the A2003 stations today (sunday) but looked at
my laptop which has A2007. In A200s there are 78 property settings including
'auto resize', 'Auto Center', and 'Fit to Page'. None of these are available
in A2000. In fact there are less than 40 property settings for reports in
A2000.

Bottom line: I guess I have to drag my sorry self into the 21st century in
the next few weeks.

While playing with thi i noticed that even though I can get the
Print/Preview window to open at 100% by setting Auto Resize to No a you
suggested, the window it opens in is way to small. Can that be chnaged by a
property setting (did not see one) or maybe at a higher level - Access
configuration setting???

Thanks for your help in getting me going in the right direction

 

[Marshall Barton]

Your reply did not solve my problem but while testing I found that A2000
does not have a report property 'Auto Resize'. At least on the version I
have. I can't get access to the A2003 stations today (sunday) but looked at
my laptop which has A2007. In A200s there are 78 property settings including
'auto resize', 'Auto Center', and 'Fit to Page'. None of these are available
in A2000. In fact there are less than 40 property settings for reports in
A2000.

Bottom line: I guess I have to drag my sorry self into the 21st century in
the next few weeks.

While playing with thi i noticed that even though I can get the
Print/Preview window to open at 100% by setting Auto Resize to No a you
suggested, the window it opens in is way to small. Can that be chnaged by a
property setting (did not see one) or maybe at a higher level - Access
configuration setting???

If a report is not maximized, it should open with the size
it had when you last saved the report's design.

I haven't looked at this in A2007, but all other versions of
Access are the same for when/how to zoom.

The DoCmd.RunCommand acCmdZoom100 line does not go in the
report. It should immediately follow the DoCmd.OpenReport
line.

IMO, you have already spent more time on this problem than
it would take to open any module and use Edit - Find
DoCmd.OpenReport

Paste the Zoom line and use F3 to get to the next one.

Repeat.

 

[Al Campagna]

Steve,
Hmmm... that odd. I don't happen to have 2000 installed, but it's odd
that 97 has AutoResize, and 2003 does too. I wouldn't have thought that
2000 dropped that property.

I'm not sure what you mean by "too small."
Does the report preview come up in a window that is not maximized, like a
small pop up window?
Have you tried the Maximize method...
DoCmd.Maximize
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Brian Ellison]

Thanks Al, this solved my problem.
Brian