I'm not sure if this is possible and have been unsuccessful in my attempts.
Scenerio: I have a report with several fields. If the data in field X = Y then shade the entire row.
I've been attempting to loop through the report using the following in the OnFormat Event:
Expand|Select|Wrap|Line Numbers
- For Each ctl In Me.Section(0).Controls
- If ctl.Column(4) = "text string here" Then
- Me.Section(0).BackColor = RGB(255, 255, 255)
- Else
- Me.Section(0).BackColor = RGB(192, 192, 192)
- End If
- Next
Bender