[AccessD] Report Preview Question

Sorry, I was none too clear.

You make the call after the report is previewed, from the code routine that
opened the report, not from within the report's module.  So...

    DoCmd.OpenReport "SomeReport", acViewPreview
    DoCmd.SelectObject acReport, "SomeReport"
    DoCmd.RunCommand acCmdZoom100

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: Thursday, February 02, 2006 4:46 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Report Preview Question


Lambert

I tried your code on the open, activate and page header
events. I got an error saying you can not use select object while it is
printing.

Any Ideas?

Thanks


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Thursday, February 02, 2006 12:51 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Report Preview Question

This will do it...
   After opening the report in preview mode...

    DoCmd.SelectObject acReport, "Some Report Name"
    DoCmd.RunCommand acCmdZoom100

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Joe Hecht
Sent: Thursday, February 02, 2006 3:38 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Report Preview Question


I have reports that I  have code to maximize on opening.

 

Does anyone know the code to set the preview size
automatically to 100%

 

Thanks

 

Joe Hecht

jmhecht at earthlink.net

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com