VBA open as report in landscape

[The_Kurgan]

I am currently using the code below to open a table as a report. It defaults to Portrait, but I would like it to open in landscape orientation. Any ideas how to do that?

DoCmd.OpenTable "MyTable", acViewPreview, acReadOnly

TIA!

 

[Joe4]

That is actually opening the Table as a Table, not as a Report.
I don't think you have the ability to edit how the Table is presented.
Why not just make a simple Report based on the Table, and then you can edit the Report properties as you like?

 

[The_Kurgan]

Interesting, because when I use the code

DoCmd.OpenTable "MyTable", acViewPreview, acReadOnly

it looks like a report.


When I use

DoCmd.OpenTable "MyTable", acViewNormal, acReadOnly

it looks like a table.


I haven't programmed an automated report yet, so I will look into that. Thanks!

 

[Joe4]

Follow the commands - they tell you what is going on:
OpenTable - you are opening a table
acViewPreview - you are opening it in Print Preview mode

The Action for opening reports is called OpenReport.

If you open the Table, and the click on Report from the Create menu, it will automatically create a report for you, which you can then customize to your likely (so you do not have to create the Report from scratch, unless you want to).

 

[The_Kurgan]

Super, thanks! I will play around with that.