Font Color in Reports

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

If I have an "amount" field that gives currency amounts
but is grouped according to "paid" and "not Paid" in a
report. Is it possible to change the font color to green
if paid and red if not paid - and how would I do it? -
thanks!
 
Yes. In design view, click your field. Go to the Format menu and select
"conditioanl formatting". Set it using the "field value is..." options.

Rick B



If I have an "amount" field that gives currency amounts
but is grouped according to "paid" and "not Paid" in a
report. Is it possible to change the font color to green
if paid and red if not paid - and how would I do it? -
thanks!
 
Sorry, you would actually need to use the "expression" option and tell it to
format the color based on what is in the "paid/notpaid" field.

Rick B


Yes. In design view, click your field. Go to the Format menu and select
"conditioanl formatting". Set it using the "field value is..." options.

Rick B



If I have an "amount" field that gives currency amounts
but is grouped according to "paid" and "not Paid" in a
report. Is it possible to change the font color to green
if paid and red if not paid - and how would I do it? -
thanks!
 
Back
Top