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

G

Guest

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

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

Guest

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

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

Top