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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export html text as word document with specific size and orientation 0
Page orientation change port to lands KEEPING PAGE NUMBERING 0
Drawing Page Orientation Doesn't Match Printer Paper Orientation 0
Creating a Macro 2
Changing paper size for report 0
Changing paper size & orientation for all sheets 0
Paper size being lost when moving to a different computer 0
How to modify and updte specific styles for specific paragraphs across the document 0

Top