R Rick Brandt Jun 8, 2005 #2 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.
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 Jun 8, 2005 #3 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...
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...
