Save Query Page Setup (Landscape, Margins)

[pianoprodigy]

Two queries I use are part of a monthly report that prints out automatically with a macro. Unfortunately, the query does not save the Page Setup information, and the information will not fit on one page.

Is there a way to tell Access to either:
Keep/Store the Page Setup info such as Landscape and Margins
OR
Put something in the Macro that will format the page automatically.

Thanks,

Alan

 

[pianoprodigy]

Okay, I just figured it out.

I used the SendKeys Action in my macro, and after a few tries, I figured out the string to change all margins to .5 and the layout to Landscape.

SendKeys %"F""U"{TAB}{BS}.5{TAB}{BS}.5{TAB}{BS}.5{TAB}{BS}.5{TAB}{TAB}{TAB}{TAB}{RIGHT}{TAB}{RIGHT}{TAB}{TAB}{TAB}{TAB}~

 

[Rich]

If you used a report you wouldn't need to use send keys.

 

[pianoprodigy]

If you used a report you wouldn't need to use send keys.

I would use a report, but I like the column setup with a query. If there is a report that will display this in the same way, I would love to know about it.

 

[Rich]

Use the Report wizard, it'll do most of the work for you