Tuesday, November 09, 2010

Microsoft Access - Report Colors Don't Print

Problem:

On the report the color coded rows look great. However, when it is sent to print we lose this capability. Is this on our end (printer issue)?

Solution:

The row colors for the report are set using VBA code in the Detail_Paint event. The same code needs to be called in the Detail_Print event.

This applies to Microsoft Access 2007. I'm not sure if it applies to other versions of Microsoft Access.

Reformation Ideas

  • understanding and comprehension of U.S. constitution demonstrated
  • secret clearance obainment required
  • strict accountability for oaths and promises made
  • no campaigning while serving a term elected to fulfill
  • term limits for all elected officials