Changing text color based on values

[rainymac]

Changing text color of row in a query based on values

I need to flag records in a query & it's table base on the results of an expression. This database has different Equipment at different Location with a DateTested compared to the current date to show the TimeSpan .

For any record that has a TimeSpan of more the 4 years, I need the entire row for those records, in the query & table, to either have a text color change or a fill color change.

Thank You for any help.

 

[Fornatian]

If you have access97 then this is not possible in either a table or a query. I believe if you search for posts by Mike Gurman on this forum there is an example attached to one of the posts on how to do this on a form using duplicated controls with different font colours for different situations.

 

[rainymac]

Thanks Fornatian.

It is Access 97 and that's good to know. Does that mean, however, that a newer version would be capable of doing this?

 

[shaggy]

I don't know about changing colors in a query, but you can do it in a report. Click on Format, and then Conditional Formatting.

 

[Fornatian]

Thanks Kevin, couldn't have answered that one fully