In a report, highlight row (in color) where there is a value of $0

  • Thread starter Thread starter R. Lee White
  • Start date Start date
R

R. Lee White

I am working with a report that I use to keep track of items outstanding for
purchase. It would be easier if the record with a value of $0 would just
print in color to distinguish it from items purchased. Is there a way to
accomplish this in Access reports?

Thanks,
 
R. Lee White said:
I am working with a report that I use to keep track of items outstanding for
purchase. It would be easier if the record with a value of $0 would just
print in color to distinguish it from items purchased. Is there a way to
accomplish this in Access reports?
Click to expand...


Use Conditional Formatting (Format menu) for the text box.

Select the Value Is: option and enter 0. Then pick your
favorite color.
 
Back
Top