I have been trying for a while to print a query in Landscape using VBA.

The query, by default is set to Portrait but i want to use VBA to set the orientation to Landscape and print it however while this seems quite straightforward for Reports and Forms the information i have found on these i have not been able to apply to a Query.

Can anyone suggest anything ?

Thanks
Rob

Make a report out of it instead of trying to print the query?

mmcdonal

I thought about this but there are about 400 queries all in all what are run in sets of upto 100.

I could make a generic report and change the recordset to point at each query one at a time and print them but that seems like a awkward way to do this and also the column widths would be a big problem and eash query displays very different data