Developer Forum

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.

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




type
with

type
with

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.