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

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

Post by UE9PS0FNQU » Thu, 17 Feb 2005 01:45:01


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.
 
 
 

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

Post by Rick » Thu, 17 Feb 2005 01:50:07

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

 
 
 

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

Post by Bria » Thu, 17 Feb 2005 01:57:18


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.