alternating color

R

Rick Brandt

Candor said:
How to accomplish?
Based on odd or even value in a field.
thanks
Click to expand...

In the format event of the section...

If Me!FieldName mod 2 = 0 Then
Me.Section(n).BackColor = vbGreen
Else
Me.Section(n).BackColor = vbWhite
End If

You will have to replace the 'n' with the appropriate index value for the
section. For the detail section it would be zero.
 
C

Candor Feg

THANKS
Rick Brandt said:
In the format event of the section...

If Me!FieldName mod 2 = 0 Then
Me.Section(n).BackColor = vbGreen
Else
Me.Section(n).BackColor = vbWhite
End If

You will have to replace the 'n' with the appropriate index value for the
section. For the detail section it would be zero.
Click to expand...
 
Top