condition background color of report body

[focosi]

I am trying to change background color of body when a control in it matches a certain value.
What I obtain with the following statement ....


Private Sub Report_Load()
Select Case [Stato]
Case "C2"
Me.Body.BackColor = vbYellow
Case Else
Me.Body.BackColor = vbWhite
End Select


End Sub

...is instead alternate colors of records ?!!?? What's wrong ??

[alansidman]

Found this slightly different approach

http://www.databasejournal.com/featu...ort-Tricks.htm

Alan

[focosi]

thanks, but unfortunately the webpage only deals with alternating row colors. Instead I want to change row color based on control value... Any hint ?