Make Reports Open 100%

[Steve]

I have many reports in my database. All but one opens at 100%. The one opens at
"Fit". How do I make that one open at 100%?

Thanks for all help!

Steve

[Wayne Morgan]

Re: Make Reports Open 100%

I was able to get it to do so by placing the following in the Detail Section's OnRetreat
event.

RunCommand acCmdZoom100

--
Wayne Morgan


"Steve" <ssmith@bellsou th.net> wrote in message
news:KZJeb.4803 $f11.2611@newsr ead1.news.atl.e arthlink.net...[color=blue]
> I have many reports in my database. All but one opens at 100%. The one opens at
> "Fit". How do I make that one open at 100%?[/color]

[Wayne Morgan]

Re: Make Reports Open 100%

ps.

This Retreat event is the only one that I found that would accept the command. The trick
is that the Retreat event may not be triggered depending on what you're doing. All the
other events on the report or its sections gave me an error that said the command can't be
run at this time. However, with further testing, I found that if I placed the RunCommand
acCmdZoom100 command right after the DoCmd.OpenRepor t call, that it appeared to work every
time.

--
Wayne Morgan


"Steve" <ssmith@bellsou th.net> wrote in message
news:KZJeb.4803 $f11.2611@newsr ead1.news.atl.e arthlink.net...[color=blue]
> I have many reports in my database. All but one opens at 100%. The one opens at
> "Fit". How do I make that one open at 100%?
>
> Thanks for all help!
>
> Steve
>
>[/color]

[Steve]

Re: Make Reports Open 100%

Wayne,

Thanks for responding!

I didn't have to do this for any of the other reports and they all open at 100%.
Why would I have to do it for this report?

Steve


"Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in message
news:CsTeb.8097 $ww7.1430@newss vr33.news.prodi gy.com...[color=blue]
> ps.
>
> This Retreat event is the only one that I found that would accept the command.[/color]
The trick[color=blue]
> is that the Retreat event may not be triggered depending on what you're doing.[/color]
All the[color=blue]
> other events on the report or its sections gave me an error that said the[/color]
command can't be[color=blue]
> run at this time. However, with further testing, I found that if I placed the[/color]
RunCommand[color=blue]
> acCmdZoom100 command right after the DoCmd.OpenRepor t call, that it appeared[/color]
to work every[color=blue]
> time.
>
> --
> Wayne Morgan
>
>
> "Steve" <ssmith@bellsou th.net> wrote in message
> news:KZJeb.4803 $f11.2611@newsr ead1.news.atl.e arthlink.net...[color=green]
> > I have many reports in my database. All but one opens at 100%. The one opens[/color][/color]
at[color=blue][color=green]
> > "Fit". How do I make that one open at 100%?
> >
> > Thanks for all help!
> >
> > Steve
> >
> >[/color]
>
>[/color]

[Rick Brandt]

Re: Make Reports Open 100%

"Steve" <ssmith@bellsou th.net> wrote in message
news:E9Veb.7327 $3S.5704@newsre ad2.news.atl.ea rthlink.net...[color=blue]
> Wayne,
>
> Thanks for responding!
>
> I didn't have to do this for any of the other reports and they all open at 100%.
> Why would I have to do it for this report?[/color]

Did you develop this app? IME reports always open at 100% unless there is code added
to make them do otherwise. Are you sure this one doesn't have that? Is the result
the same when you open from the db window as opposed to using a command button to
open it?

[Steve]

Re: Make Reports Open 100%

Rick,

Thanks for the comments!

Yes, it opens in "Fit" from the database window too.

Steve


"Rick Brandt" <rickbrandt2@ho tmail.com> wrote in message
news:blh778$c5h 5p$1@ID-98015.news.uni-berlin.de...[color=blue]
> "Steve" <ssmith@bellsou th.net> wrote in message
> news:E9Veb.7327 $3S.5704@newsre ad2.news.atl.ea rthlink.net...[color=green]
> > Wayne,
> >
> > Thanks for responding!
> >
> > I didn't have to do this for any of the other reports and they all open at[/color][/color]
100%.[color=blue][color=green]
> > Why would I have to do it for this report?[/color]
>
> Did you develop this app? IME reports always open at 100% unless there is[/color]
code added[color=blue]
> to make them do otherwise. Are you sure this one doesn't have that? Is the[/color]
result[color=blue]
> the same when you open from the db window as opposed to using a command button[/color]
to[color=blue]
> open it?
>
>[/color]

[Trevor Best]

Re: Make Reports Open 100%

On Thu, 02 Oct 2003 14:05:26 GMT in comp.databases. ms-access, "Steve"
<ssmith@bellsou th.net> wrote:
[color=blue]
>Rick,
>
>Thanks for the comments!
>
>Yes, it opens in "Fit" from the database window too.[/color]

I can't find a pattern to this, my scratch cdma database had but one
report, it opened in "Fit". I created a new report (using "columnar
wizard") and it opened in "100%", I save it, closed it, opened it
again and it opened in "Fit". Balmy.

In my live apps, I generally have a profile set for preferred view and
use the method that Wayne posted so I never really noticed it before.

--
A)bort, R)etry, I)nfluence with large hammer.

[Wayne Morgan]

Re: Make Reports Open 100%

Rick,

I've found that to usually be the case, but I have a few that don't also. I haven't been
able to pin down a common cause yet. If I go from design view to preview it opens at 100%,
if I open it from the database window it opens at Fit. I didn't notice this in earlier
versions of Access, but XP seems to like to do this.

I just did some more playing around. It appears that if I turn Auto Resize off in the
report's properties that it opens at 100%, if Auto Resize is on, it opens at Fit.

--
Wayne Morgan


"Rick Brandt" <rickbrandt2@ho tmail.com> wrote in message
news:blh778$c5h 5p$1@ID-98015.news.uni-berlin.de...[color=blue]
> "Steve" <ssmith@bellsou th.net> wrote in message
> news:E9Veb.7327 $3S.5704@newsre ad2.news.atl.ea rthlink.net...
> Did you develop this app? IME reports always open at 100% unless there is code added
> to make them do otherwise. Are you sure this one doesn't have that? Is the result
> the same when you open from the db window as opposed to using a command button to
> open it?[/color]