Report view

[Bob]

I wish to have a Report open maximised AND with the size to fit the screen.
The "DoCmd" works to open maximised but how do I make it fit the screen in
VBA code??

Thanks, Bob.

[Rick Brandt]

Bob wrote:

I wish to have a Report open maximised AND with the size to fit the
screen. The "DoCmd" works to open maximised but how do I make it fit
the screen in VBA code??

Thanks, Bob.

DoCmd.RunCommand acCmdFitToWindow

This has to be run in the code that opens the Report. It cannot (for some
silly reason) be run from the Report's own code module (like the Open event
which would be the logical place for it).

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[lylefair]

I posted this via Cogeco but Cogeco and Crap start with the same
letter. Apologies if Cogeco actually works and this is posted twice.

I believe ZoomControl is a hidden property of reports and forms.
The value assigned is the per cent of "zoom" wanted.
Zero maps to "size to fit".

example: (this is code from a working application)

With DoCmd
.OpenReport "rptActualOrganizationandStaffing", acViewPreview
.ShowToolbar "Print Preview", acToolbarNo
.Maximize
End With
Reports("rptActualOrganizationandStaffing").ZoomCo ntrol = 0

Developers have different opinions about hidden objects and methods. Of

course, MS makes no committment to maintain these. But MS makes no
committment to maintain anything (see my signature line). I have been
using
various hidden objects and methods from Access97 through Access2003.
None
has ever been removed or changed.
But, many developers will advise against their use.
You choose.

--
Lyle

Data Access Objects (DAO): DAO provides access to JET (Access)
databases.
This API can be used from Microsoft Visual Basic®, Microsoft Visual
C++®,
and scripting languages. It was included with Microsoft Office 2000 and

Office XP. DAO 3.6 is the final version of this technology. It will not
be
available on the 64-bit Windows operating system.

[Lye Fairfield]

"Bob" <di**@attglobal.net> wrote in news:42********@news1.prserv.net:

I wish to have a Report open maximised AND with the size to fit the
screen. The "DoCmd" works to open maximised but how do I make it fit
the screen in VBA code??

Thanks, Bob.

I believe ZoomControl is a hidden property of reports and forms.
The value assigned is the per cent of "zoom" wanted.
Zero maps to "size to fit".

example: (this is code from a working application)

With DoCmd
.OpenReport "rptActualOrganizationandStaffing", acViewPreview
.ShowToolbar "Print Preview", acToolbarNo
.Maximize
End With
Reports("rptActualOrganizationandStaffing").ZoomCo ntrol = 0

Developers have different opinions about hidden objects and methods. Of
course, MS makes no committment to maintain these. But MS makes no
committment to maintain anything (see my signature line). I have been using
various hidden objects and methods from Access97 through Access2003. None
has ever been removed or changed.
But, many developers will advise against their use.
You choose.

--
Lyle

Data Access Objects (DAO): DAO provides access to JET (Access) databases.
This API can be used from Microsoft Visual Basic®, Microsoft Visual C++®,
and scripting languages. It was included with Microsoft Office 2000 and
Office XP. DAO 3.6 is the final version of this technology. It will not be
available on the 64-bit Windows operating system.

[Bob]

Rick & Lyle

Thanks for your help, Bob.