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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Yea just copy and paste it. Notepad will leave unformatted and spaced like
the VB code editor.
 
Back
Top