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

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

 

[Marshall Barton]

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?

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

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