Color row in Report based on Condition of Cells in a Column

[CW Moss]

Hello,

Could someone please help me.
I would like the color of an entire row change if the condition in column B (Duration Hour) matches the criteria below in a Access 2003 Report.

If B is less than 12 then then row is remains white
If B is between 12and 24 then the row is highlighted yellow
If B is greater than 24 then the row is highlighted red

I tried to paste in an example below but only the text displayed.

A____________B
Process__Duration Hours
1 AT31___ 187.7 Row should be Highlighted Red

2 AT32___ 261.2 Row should be Highlighted Red

3 AT33___ 4 No Highlight

4 AT34___ 493.53 Row should be Highlighted Red

5 AT35___ 11.99 No Highlight

6 AT36___ 18.2 Row should be Highlighted Yellow

7 AT37___ 640.7 Row should be Highlighted Red

8 AT47___ 33.7 Row should be Highlighted Red

9 AT48___ 3.7 No highlight

10 AT49__ 1594.7 Row should be Highlighted Red

11 AT50__ 12 Row should be Highlighted Yellow

12 AT51__ 23.7 Row should be Highlighted Red

Thanks for your help in advanced.

 

[Norie]

What you need to do is put code in the Format event of the Detail section of the report.

Perhaps something like this.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Select Case DurationHours
        Case > 24
             Detail.BackColor = vbRed
        Case 12 to 24 
             Detail.BackColor = vbYellow
        Case Else
             Detail.BackColor = 16777215
    End Select
End Sub

 

[CW Moss]

Norie,

Perfect, I ran a quick test and it appears to do just what is needed. I had to make two small adjustments as follows;

Case >= 24

Case 12 to 23.99

Hopefully one day I will be able to return the favor to you or at least pass what I have learned on to someone in need.

Again Thanks