Check this one out...
>-----Original Message-----
>I have a button on my form that when clicked will use the 'PrintOut' macro
>event
>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?
>
>Cheers!
>
>
>
>
>.
>
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_SwitchView_Click:
Exit Sub
Err_SwitchView_Click:
MsgBox Err.description
Resume Exit_SwitchView_Click
End Sub
--------------------------------------------------------------------------------
slypunk