Font color & background color in a query possible

[Guest]

Is it possible to have font colors or background colors change in a query.

I have a simple select query that selects 2 fields from 2 tables. I then
have a IIF statement that if the records match, display "PASS", if not match
display "FAIL".
Is it at all possible thru code or query builder to have the word PASS
display in green color and the word FAIL display in red (or whatever font
color).

and is it possible to fill the background of each PASS or FAIL record with a
colored background.
If not can it be done in a table?

much thanks for your help!

 

[fredg]

Is it possible to have font colors or background colors change in a query.

I have a simple select query that selects 2 fields from 2 tables. I then
have a IIF statement that if the records match, display "PASS", if not match
display "FAIL".
Is it at all possible thru code or query builder to have the word PASS
display in green color and the word FAIL display in red (or whatever font
color).

and is it possible to fill the background of each PASS or FAIL record with a
colored background.
If not can it be done in a table?

much thanks for your help!

No, not in a query.
You can create a report, using the query as it's record source,
or create a form, in Datasheet View, that uses the query as it's
record source. Then you can use Conditional Formatting to change the
color of the controls.

 

[Jeff Boyce]

Bret

Consider using a form to display the results of your query. Conditional
formatting is available in forms, but I'm not aware of a way, out of the
box, to do this in a query.

Good luck

Jeff Boyce
<Access MVP>