print query in landscape

[Guest]

I have a button on my form that when clicked will use the 'PrintOut' macro
event to print a cross tab query that comes from a make table query.

Is there an extra bit of code I can run that will make the query print in
landscape instead of portrait?

Cheers!

 

[Guest]

This is only possible from vba.

You can set the orientation by using the following code:

currentdb.QueryDefs("Your Query Name").Properties("Orientation")=0 ' Portrait
currentdb.QueryDefs("Your Query Name").Properties("Orientation")=1 ' Landscape

However you can run this code from a macro then you just have to create a
module with 1 function

public Function SetLandscape(QueryName as string) as boolean
currentdb.QueryDefs(QueryName).Properties("Orientation")=1 ' Landscape
end function

 

[Guest]

i am using access 2000. i've tried what you suggests but it still won't work
the preview is still portrait.