page setup

[brendamg]

access 2000 reports
How to code page set in access VBA

 

[cghoga]

SendKeys "^P", False

 

[randysmid]

HI,
Can you let us know exactly what it is you want to do? To get you started, most report properties can be set in the report's open event.

HTH,
Randy Smith, MCP
California Teachers Association

 

[brendamg]

I have written a report in access VBA, i.e. actually coding the header, detail and footer sections. The report needs to be printed in landscape and on legal size paper. I also need to code the page set for the margins. Since the report cannot be done in the design view and has to be coded, I need to code the page setup.

 

[randysmid]

Hi,
Here is a link to a downloadable file that has code samples on how to accomplish this:

http://dbforums.com/t522712.html

(scroll down until you see "margindemo.zip"

I downloaded it without any troubles. After unzipping it, you will need to convert to Access 2000, unless you are using Access 97. Take a look at the Modules section. You will see a number of code snippets including "basSetMargins".

HTH,
Randy Smith, MCP
California Teachers Association