reports with dynamic color

[BMan111]

I have an executive summary report I am working on, and I am getting stuck on somethign very easy. I have an input form where the user enters wether or not they are on schedule, ahead, in danger of missing a date, or will deffinatly be missing a deadline. this stores a 0,1,2,or 3 in a field.

This field, as well as the field it is a control for, are in the query that controls the form.

I need the color of the date fields to change color based on these 4 numbers. Which is easy enough, a simple nested if or a case statement, problem solved. However, it seems that whatever I do, sets the color in the first record, then doesn't ever change, once the first one turns green, all of those dates are highlighted green.

So I think the main problem is where should I put this code inside of the report?

Brandon