Macro to change on-the-fly report orientation, paper size

  • Thread starter Elizabeth Swoope
  • Start date
E

Elizabeth Swoope

I'm generating a crosstab using a query. I'd like to create a macro that does
Print Preview, changes the page layout to landscape, and changes the paper
size to legal. I can teach my users to just click the appropriate options but
it would be nice if I could have a macro.

I don't want to create a report based on this crosstab because the column
headings will be different from department to department, and there's even a
possibility that they'll change from time to time for a given department.

This ought to be really simple. I found the PageSetup and PageProperties
arguments, but Help isn't at all helpful!

Thanks,

liz
 
Top