Hi Everyone,

Is there a way that the page setup properties for a report, such as
page size, orientation, margins can be obtained without needing to
open the report in design view? I am hoping that this info might live
in a system table somewhere or similar. The goal is to refine a report
to powerpoint block of code I have written (which I must say I am
quite proud of!). If the only way is through design mode then I have
to re-write a large chunk of code - possible but annoying. I am hoping
someone knows a shortcut or alternative method to this.

Cheers

The Frog

See help on PrtMip, PrtDevMode, etc.

You need to open the report to read these, but I don't think it has to be in
design view.

In A2002, you can examine the properties of the Printer object, but that
won't necessarily tell you about a specific report's properties.

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"The Frog" wrote in message
news:55477cc5-425b-4e43-a3bb-701a5022f81c (AT) n10g2000yqd (DOT) googlegroups.com...

Hi Everyone,

Is there a way that the page setup properties for a report, such as
page size, orientation, margins can be obtained without needing to
open the report in design view? I am hoping that this info might live
in a system table somewhere or similar. The goal is to refine a report
to powerpoint block of code I have written (which I must say I am
quite proud of!). If the only way is through design mode then I have
to re-write a large chunk of code - possible but annoying. I am hoping
someone knows a shortcut or alternative method to this.

Cheers

The Frog

Perfect! Thanks Allen.

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

Cheers

The Frog

On Tue, 30 Nov 2010 04:05:07 -0800 (PST), The Frog
<mr.frog.to.you (AT) googlemail (DOT) com> wrote:

Ah, read only in non design view. I didn't know that.

Thanks for posting the URL.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/