access2007 reports opening at 69%

#1

in access97, this statement opens the report at 100%
DoCmd.OpenReport "rptAuditPurWrongWhse", acViewPreview

but in access2007, it only opens at 69% and clicking on the report,
zooms it out to 100%

is there an option to automatically open the report at 100% ?

#2

On Aug 18, 9:25*am, Roger <lesperan... (AT) natpro (DOT) com> wrote:

Quote:

in access97, this statement opens the report at 100%
* * * *DoCmd.OpenReport "rptAuditPurWrongWhse", acViewPreview

but in access2007, it only opens at 69% and clicking on the report,
zooms it out to 100%

is there an option to automatically open the report at 100% ?

After the .OpenReport line add: DoCmd.RunCommand acCmdZoom100

Just to make sure the user sees only the requested report I add:
DoCmd.Maximize

HTH

Tim Mills-Groninger

#3

On Aug 18, 10:32*am, timmg <tmillsgronin... (AT) gmail (DOT) com> wrote:

Quote:

On Aug 18, 9:25*am, Roger <lesperan... (AT) natpro (DOT) com> wrote:

in access97, this statement opens the report at 100%
* * * *DoCmd.OpenReport "rptAuditPurWrongWhse", acViewPreview

but in access2007, it only opens at 69% and clicking on the report,
zooms it out to 100%

is there an option to automatically open the report at 100% ?

After the .OpenReport line add: DoCmd.RunCommand acCmdZoom100

Just to make sure the user sees only the requested report I add:
DoCmd.Maximize

HTH

Tim Mills-Groninger

but I'd have to do this for all reports ?
isn't there a global access setting for this ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

access2007 reports opening at 69%

comp.databases.ms-access comp.databases.ms-access

access2007 reports opening at 69% - 08-18-2010 , 09:25 AM

Re: access2007 reports opening at 69% - 08-18-2010 , 11:32 AM

Re: access2007 reports opening at 69% - 08-18-2010 , 01:53 PM