Print Button Properties

[data808]

I have a report with a print button that has simple vba behind it.


On Error Resume Next
Docmd.Runcommand acCmdPrint




The problem is that the properties don't save for landscape. It always defaults to portrait. However, I have another database that when I create the same type of print button, it defaults to landscape. Does anyone know why this is happening?

[data808]

Its shocking no one replied with a solution to this. Luckily I was able to figure it out myself.

All reports in design view have a page setup tab in the ribbon that you can set the orientation to landscape as a default option. Its so simple yet I thought I was going to have to use VBA or something to achieve this.