Simple problem from a simple man

A

anthony.carter

Hi,

I have a table which records several different scores for each
record / entry. Is there a way that the report based on the query , in
turn based on the table, will show the scores below a certain level in
a different coloured font?

Cheers,

TC
 
D

Dirk Goldgar

Hi,

I have a table which records several different scores for each
record / entry. Is there a way that the report based on the query , in
turn based on the table, will show the scores below a certain level in
a different coloured font?
Click to expand...

I believe Conditional Formatting (available in Access 2000 and later
versions) will do what you want. With the report open in design view,
select the text box or boxes you want to do this with, then click menu
items Format -> Conditional Formatting..., and define the condition and
format -- in this case, fore/font color -- that you want to apply when
that condition is true.
 
Top