Conditional Formatting in A97

[Becca]

Hi

I would like to conditionally format specific records in the detail section of my report.

The records have a yes/no record associated with them indicating if the entry is blocked for entry and hence should be highlighted in the report.

I don't want to highlight the entire Detail section - just the controls within the section, this way I can have multiple lines with different colours.

Its driving me nuts trying to do this, as nothing I do seems to make the feilds change colour. Here is an example of my current vb

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.ENTRYBlocked_ = True Then
Me.SumOf2000_01.BackColor = vbRed
Else
Me.SumOf2000_01.BackColor = vbWhite
End If
End Sub

Not working however, any ideas form the gurus out there?

 

[Becca]

Never mind - I found what I was doing wrong almost straight away - nothing wrong with the code, just hadn't changed my back style to "normal"



duh-oh