Changing text color based on data

[Luna Saisho]

I have a crosstab query that helps create a vacation schedule, where the
calendar is set up accross the report from 1-31, where the hours an employee
took are listed under the day of the month. My manager asked me today to see
if I can set it so the # hours (which is listed under each day if they take a
day off) can be changed to another color if it hasn't been approved yet. All
the text is black right now.

I set up the date entry to have a checkbox to check if it's been approved,
defaulting to checked (Yes) since most are approved by the time they hit my
DB. Is there a way to change the color to, say, red if it's not yet approved?

Thank you!
Stephanie

 

[Duane Hookom]

You would need to "push" the checkbox value to the crosstab. One method
would be to set the Value in the crosstab to a negative if the hours haven't
been approved. You could then use code or conditional formatting to color
the negative numbers different from the positive numbers.