Why Does Report Open with Zoom Set to "Fit" 1

[RH610]

Why does a report open with zoom set to "Fit". It only does this on one PC.

Thanks

 

[scriverb]

Check the resolution differences between the PC's. Sometimes a user sets there's different and the report or form takes up the whole page because of the resolution settings.

Let me know if this is it. Bob Scriver

 

[RH610]

Hi, Thanks for replying.

Resolution is the same on both PCs. On one the reports opens at 100% zoom; on the other it opens with the zoom at "fit". Would like it to be 100%.

 

[scriverb]

In the code event procedure where you trigger the opening of the report use this:

DoCmd.OpenReport "rptYourReport", acViewPreview
DoCmd.Maximize

This will maximize the preview report window on all PC's. Bob Scriver

 

[Bry12345]

Add the following line to scriverb's code:

DoCmd.RunCmd acCmdZoom100

You can change the '100' to other zoom levels at well.

There is some issue regarding where this code has to run for it to work . . it works fine if it is run from a module, but may fail elsewhere.
- - - -

Bryan

 

[scriverb]

Bry12345: That's a new one for me. Thanks. So, after we maximize the window we can zoom to whatever percent we want to just like the preview window's zoom combobox? Should that zoom command maybe be in the OnLoad of the report? Is that where it maybe doesn't work? Bob Scriver

 

[Bry12345]

Bob,

I believe it won't work in the OnLoad event . . I'm pretty sure that was the issue, but didn't post it before because I wasn't sure. In earlier codings, I would have put the 'maximize' in the OnLoad Event, so the 'Zoom' is probably why I'm running it from a module now.

I've got it running in a module and it works fine. - - - -

Bryan

 

[scriverb]

I will give this a try. Thanks Bob Scriver

 

[p7eggyc]

I am having a similar problem in that a report we have used for a long time always opened at 100% but since converting to XP last week, it now opens to "fit" instead. This is an Access 2000 file opening in XP. I really don't want to go in and do a bunch of coding if I can avoid it. Does anyone know of a preference or option that may have been set that got "lost" in the upgrade?? Thanks.

Peggy

 

[scriverb]

p7eggyc: I don't believe that that there is an option that can be set for this but the only line of code that needs to be added is the one indicated above.
DoCmd.OpenReport "rptYourReport", acViewPreview
DoCmd.Maximize
DoCmd.RunCmd acCmdZoom100

This will open the report for preview with its window maximized and its zoom set to 100%. Bob Scriver