Tabular data can be tough to read; I frequently want my reports to have alternate lines shaded to make the data easier to follow.
Shading Alternate Details Lines
- Right-click the Details section name.
- Select Section Expert.
Click the color tab and click the Conditional Formatting button.
To shade every other line, enter the formula
If RecordNumber Mod 2 = 0 Then crSilver else crNoColor
To shade every two lines, enter the formula
If RecordNumber Mod 4 in 1 to 2 Then crSilver else crNoColor
Click OK twice, and preview your report.