conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This db is for tracking customer dollar agings. How much is owed to us at any
giving time. All works well, but I am added a field to track disputed
invoices. What I need is if a value shows up in a certain record in this
field, I want it to highlight the complete record in say Yellow. I don't want
to have to build a report or form for this. I would like this to pop up when
a certain query is ran. I have IS NULL working with a number of fields, but
this just returns certain types of records. Can I do something like this with
the NULL?
 
Well, I am just looking for an easy way to highlight the record in yellow
if there is a value in the dispute field.
 
Back
Top