By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,283 Members | 1,721 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,283 IT Pros & Developers. It's quick & easy.

determining a report's page orientation with VBA

P: n/a
tom
Hi All,

Using VBA, I would like to be able to examine a report in design
mode and determine its page orientation (landscape or portrait).

I do not want to change the orientation.

I'm fine with getting to the point of having an Access.Report
variable pointing to the report... just don't know how to get it to
tell me its page setup information.

Any ideas?

Thanks,
-Tom
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 4 Jun 2004 17:40:27 -0700, tom wrote:
Hi All,

Using VBA, I would like to be able to examine a report in design
mode and determine its page orientation (landscape or portrait).

I do not want to change the orientation.

I'm fine with getting to the point of having an Access.Report
variable pointing to the report... just don't know how to get it to
tell me its page setup information.

Any ideas?

Thanks,
-Tom


Look up the PrtDevMode property in VBA help.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

P: n/a
tom
Fred,

Thanks for the suggestion. It seems right on, however I can't talk
Access into making it go... the "switchOrient" example on the help
page doesn't work, as the "intOrientation" field in the structure is
always 0. Hmmm....

-Tom

fredg <fg******@example.invalid> wrote in message news:<am****************************@40tude.net>.. .
On 4 Jun 2004 17:40:27 -0700, tom wrote:
Hi All,

Using VBA, I would like to be able to examine a report in design
mode and determine its page orientation (landscape or portrait).

I do not want to change the orientation.

I'm fine with getting to the point of having an Access.Report
variable pointing to the report... just don't know how to get it to
tell me its page setup information.

Any ideas?

Thanks,
-Tom


Look up the PrtDevMode property in VBA help.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.