Article ID: 114086 - View products that this article applies to.
This article was previously published under Q114086
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
This article shows you how to shade every other detail line on a Microsoft Access report.
This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Visual Basic for Applications, please refer to your version of the "Building Applications with Microsoft Access" manual.
NOTE: Visual Basic for Applications is called Access Basic in Microsoft Access versions 1.x and 2.0. For more information about Access Basic, please refer to the "Introduction to Programming" manual in Microsoft Access version 1.x or the "Building Applications" manual in Microsoft Access version 2.0.
NOTE: This article explains a technique demonstrated in the sample files, RptSampl.exe (for Microsoft Access for Windows 95 version 7.0) and RptSmp97.exe (for Microsoft Access 97). For information about how to obtain these sample files, please see the following articles in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/145777/EN-US/ )ACC95: Microsoft Access Sample Reports Available in Download Center
(https://support.microsoft.com/kb/175072/EN-US/ )ACC97: Microsoft Access 97 Sample Reports Available in Download Center
The following example uses an event procedure to alternate the background color between white and yellow. On black and white printers, yellow typically appears as light gray.
Article ID: 114086 - Last Review: January 9, 2015 - Revision: 2.3