BackColor Problem

[lansel]

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

 

[SforSoftware]

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

 

[lansel]

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

 

[SforSoftware]

You helped make my day a lot shorter.

?? For me it's still 24 hours