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

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,
 
M

Marshall Barton

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.
 
Top