Colouring alternate detail lines code doesn't work

[Daveo]

Hi there,

I used the following code on one report and it worked perfectly.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Section(0).BackColor = vbWhite Then
Me.Section(0).BackColor = 14742526 ' tan colour
Else
Me.Section(0).BackColor = vbWhite
End If

End Sub

However, I have another report which is very similar to the first one,
except it has an extra level of grouping on a particular field with a
group header and footer. With this report, the code doesn't work and
all the lines remain white. Does anyone know why this is?


Many thanks,

David

 

[Rick Brandt]

Hi there,

I used the following code on one report and it worked perfectly.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Section(0).BackColor = vbWhite Then
Me.Section(0).BackColor = 14742526 ' tan colour
Else
Me.Section(0).BackColor = vbWhite
End If

End Sub

However, I have another report which is very similar to the first one,
except it has an extra level of grouping on a particular field with a
group header and footer. With this report, the code doesn't work and
all the lines remain white. Does anyone know why this is?

Are you still trying to change the color of the Detail section? That is what
Section(0) is.

Do you still have the code in the Detail section's Format event?

Did you remember to put [Event Procedure] into the OnFormat event property box?