Access 2000 Report - Alternating Row Color

Question

I inherited the MS Access database and my new job. I don't know much about Access, and they asked if I could make any other line of the report a different color to make it easier to read. Is there an easy way to do this?

Answer 1

This is pretty easy to do. The easiest way I found for this is to use the following code:

Option Explicit Dim ColorDetail As Boolean Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If ColorDetail Then Detail.BackColor = 16777215 Else Detail.BackColor = 13290186 End If ColorDetail = Not (ColorDetail) End Sub