Share via

VBA Code documentation in Access

Anonymous
2016-07-02T19:06:52+00:00

When documenting my database, I print the VBA code for forms, etc.  It prints in black & white.  The comments are identified in green on the screen.  Is there anyway I can print the VBA code with the comment in color?  I've tried copying directly to WORD but the color doesn't come through.  I've used a screen capture program (SnagIt) and the color copies, but it comes as an image, not text.

Any insight would be greatly appreciated,

Jeff

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

HansV 462.6K Reputation points
2016-07-02T19:17:53+00:00

The Visual Basic Editor itself doesn't support printing in color or exporting the code complete with color.

PrettyCode.Print (http://submain.com/products/prettycode.print.aspx) is no longer being developed or supported, but it's free. You might give it a try.

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2016-07-04T02:56:11+00:00

    Thank you HansV.  This reminds me of a printer driver I used in the 70's to print IBM 1800 Assembly Language code. Quite happy with the outcome.  Jeff

    Was this answer helpful?

    0 comments No comments