G
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!
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!