In Access 2007, I have a report, rptWorkarounds, with the field, Workaround_Status, that is filled with Open or Resolved. I'd like the line of the report to change to a gray background when I change the status to Resolved. So far, I have this, but it's not working.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Workaround_Status = "Resolved" Then
Me.Section(acDetail).BackColor = 12632256 'grey
Me.Section(acDetail).BackColor = 16777215 ' std white