How do you control margin sizes when making a VBA code printout?

D

David Anderson

For various reasons, I like to keep a printed copy of all the VBA code I have
created for each of my Access 2000 database applications. I do this by
selecting File/Print while in the VBA window. Margin size settings are
normally provided by the application rather than the print driver, but my
problem is that I cannot see anywhere in VBA to control the size of these
margins and I always get margins of about 5 mm. This is very inconvenient, as
such margins are too small to enable me to staple the pages together without
obscuring some of the code on every page.

Is there a better way, or have I missed something obvious?

David
 
O

OldPro

For various reasons, I like to keep a printed copy of all the VBA code I have
created for each of my Access 2000 database applications. I do this by
selecting File/Print while in the VBA window. Margin size settings are
normally provided by the application rather than the print driver, but my
problem is that I cannot see anywhere in VBA to control the size of these
margins and I always get margins of about 5 mm. This is very inconvenient, as
such margins are too small to enable me to staple the pages together without
obscuring some of the code on every page.

Is there a better way, or have I missed something obvious?

David
Click to expand...

Access doesn't have that feature as far as I know. Copy the code to
Microsoft Word first and print it from there.
 
P

Paterson

Yea just copy and paste it. Notepad will leave unformatted and spaced like
the VB code editor.
 
Top