I have a report that I am trying to display numbers in red if actual did not meet the guideline. I can't get just the outside the guidelines to be displayed in red. Even if the number meets the guideline, it is printed in red.

If Me.[2nd Week Eff] < 0.45 Then
Me.[2nd Week Eff].BackColor = "255"
End If

I use the same for all weeks and the guideline number is changed for each week.

What am I doing wrong?

Thanks,

lansel

Lansel,

you've to use an Else-part, because now after the first line is printed red, every line is printed red.

It might be this:If Me.[2nd Week Eff] < 0.45 Then
Me.[2nd Week Eff].BackColor = "255"
Else
Me.[2nd Week Eff].BackColor = "0"
End If

good luck,
Bert

Thanks Bert. With your response, I was able to make the correction. I had previously included the "Else" statement, but I didn't end each section with "End If".

Now it works.

Thanks you very much. You helped make my day a lot shorter.

lansel

Originally posted by lansel
You helped make my day a lot shorter.?? For me it's still 24 hours :D