My report includes the following code. No matter what I try, Painting_Label always has the grey back color. The Painting object is a checkbox, bound to a boolean in the data source table. I have replaced this report object by copying, pasting and modifying another object of the same type. I have replaced it by creating an entirely new object. I have changed to code to alter the label's border from Transparent to Solid if Painting = True -- and even with this change, the label's border is always solid. There are many, many other objects of this same type, with this same logic, on the report and all behave as programmed except for this one. Any help will be greatly appreciated.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
lngGrey = RGB(224, 224, 224)
lngWhite = RGB(255, 255, 255)
Painting_Label.BackColor = lngWhite
If Painting = True Then Painting_Label.BackColor = lngGrey
End Sub