Printing Modules to pdf for offline analysis

[roaftech]

I have two versions of my database - one for day-to-day work, entering data and preparing reports; the second for development. When I am satisfied with changes to the second I then introduce them to the live version. Normally, I can just copy the revised module as a complete replacement but sometimes I want to incorporate part of a module. I want to be able to compare the existing and revised versions on a line by line basis (anyone remember the Filediff routine in DOS?) and in order to do this I want to be able to print the modules.
Now the problem:
When I print the module to my pdf printer it drops the first three characters on each line - there is no page setup menu that would allow setting margins in VBA. It also drops all the colour elements, such as those indicating comments or keywords, plus the separating lines between the subroutines. I can [Ctrl-A] and [Ctrl-C] the module into Notepad ++ without losing any text but again it drops the colour and separation formats. Most of my modules are too long for a simple screen-capture.



Any ideas on how to print these modules without losing the formatting?

[orange]

There is a tool that works with Access 2003. It's called DATABASE MERGE ANALYSIS TOOL.
It was written by Bob Larson. It shows the differences in things.
You can find it here

[trevor40]

Try Notepad++ WITH formatting, select VB from the list of available formats under Language menu.
It handles all VB script as it sould be, inc color and layout.

ability to Compare 2 files is in Notepad++
A very useful diff plugin to show the difference between 2 files (side by side).

you'll need to get the Addin though.

[roaftech]

Thanks guys for two prompt and helpful replies.