Hi, I would like to customize the colors that my continuous forms use for the alternating bands. I discovered that setting the 'On Paint' event for the 'Detail' section of my form in VBA is able to set the form background in alternating colors, but the cells seem to sit on top of the alternating stripes, unchanged.
My VBA is:
Code:
Private Sub Detail_Paint()
Detail.BackColor = &HDDDDDD
Detail.AlternateBackColor = &H8EAD00
End Sub
But the results are:
How can I customize the cell colors in alternating rows?