Conditional Formatting Problem with Is Null

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

Guest

I have a report that has 2 fields that I need formated a different color when
the value is empty. They are [Height] & [Weight]. I have done conditional
formatting for them and [Weight] works but [Height] does not. My expression
is as follows:
[Height] Is Null. I have doublechecked my spelling. What else could make
this not work when the exact expression for [Weight] does work?
 
I expect your issue is using a field name that is also a property of
controls. Try change the name of your field in the report's record source to
something like "Hght" or "ItemHeight". Then update your report controls to
use the new column name.
 
Back
Top