HOW DO I CHANGE FONT COLOR OF A SINGLE RECORD OF A QUERRY, NOT AL.

P

POOKAMAN

I have querried my tables and I want to distiguish certain records of the
querry by different color fonts;i.e. 25 records in querry in black font type
and want to turn 5 to red font type. Still want all 25 records, just 5 with
red font type. How do I do this? Tried different things and it changes all
the records.
 
R

Rick B

Well, you can't do it in a query, but you can create a form based on that
query and set the conditional formatting.

Rick B
 
B

Brian

POOKAMAN said:
I have querried my tables and I want to distiguish certain records of the
querry by different color fonts;i.e. 25 records in querry in black font type
and want to turn 5 to red font type. Still want all 25 records, just 5 with
red font type. How do I do this? Tried different things and it changes all
the records.
Click to expand...

1. You are more likely to get a response if you refrain from SHOUTING in
your subject line.

2. You can't. The only way in Access to get a list of records displayed
with differential formatting is to use a continuous form, and set up
Conditional Formatting for each control (from the Format menu). This
assumes at least Access 2000, Conditional Formatting didn't exist in earlier
versions.
 
Top