View Single Post
  #3 (permalink)  
Old June 6th, 2003, 12:56 PM
sherr8 sherr8 is offline
Authorized User
Join Date: Jun 2003
Location: Neverland, FL, USA.
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts

Check this one out...

>-----Original Message-----
>I have a button on my form that when clicked will use the 'PrintOut' macro
>to print a query.
>Is there an extra bit of code I can run that will make the query print in
>landscape instead of portrait?
Look up the "PrtDevMode Property" in Access 2K help. Click
on "Example" and see if this will help. I use the Sub
SwitchOrient in my VB code for switching from portrait to
landscape on reports and it works nicely.

You have to place the Type statements and the SwitchOrient
sub (included in Example) in your Standard module.

Then I use a commandbutton on the form that runs the
report. This allows the user to switch from portrait to
landscape by pressing the commandbutton called SwitchView.
Module code for this is:

Private Sub SwitchView_Click()
On Error GoTo Err_SwitchView_Click

    SwitchOrient "MyReport"

    Exit Sub

    MsgBox Err.description
    Resume Exit_SwitchView_Click

End Sub


Reply With Quote