determining a report's page orientation with VBA

[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

[fredg]

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.

[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.