Conditional Formating

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

Guest

I have a report with one of the text boxes with the value brought in from the
report's underlying query. 2 other text boxes are using DLookUp. I've set
each of these up with conditional formating ....
One of the DLookUp boxes is set to be red if less than zero. It is working.
The other two boxes are set to be red if greater than 1. Neither of these
is working.

Any ideas?
Thank you
 
Sorry...Pls let me revise this:
1 Text Box is data from the underlying query: the conditional formating is
setup so that if the value is greater than 1, it is red: THIS ONE IS NOT
WORKING
1 Text Box is and Expression and is set to be red if the value is less than
0. This Is Working
1 Text Box is using DLookUp and is set to red if it is greater than 1. This
is now working

Any idea what I may be doing wrong with the conditional formating for the
data coming into the report from the underlying query?
Thank you
 
Back
Top