D
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
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