Conditional formatting not working

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

Guest

I have a text box that has a running sum of totals set up like this
=nz(Sum([Shop Hrs]))

Under the conditional format I have it set up that if the field value
is less than 3000 then format the background yellow
is in between 3001 through 3500 then format the background green
is greater than 3500 then format the background red

When I run my report the formats are working some of the time. They all
have colors, just not the right ones. Some field values that are onl 884 are
red.

Any thoughts or suggestions are appreciated. Thanks in advance.
 
Sounds like Access is not understanding the values as numbers.

Try:
=Nz(Sum([Shop Hrs]), 0)
and set the Format property of the text box to:
General Number
or similar.

If that doesn't work, you could try typecasting. More info:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html
 
Thank you for the reply. That did not work though. Everything is set as you
suggested. I will try the link you recommended.

Allen Browne said:
Sounds like Access is not understanding the values as numbers.

Try:
=Nz(Sum([Shop Hrs]), 0)
and set the Format property of the text box to:
General Number
or similar.

If that doesn't work, you could try typecasting. More info:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

cna48 said:
I have a text box that has a running sum of totals set up like this
=nz(Sum([Shop Hrs]))

Under the conditional format I have it set up that if the field value
is less than 3000 then format the background yellow
is in between 3001 through 3500 then format the background green
is greater than 3500 then format the background red

When I run my report the formats are working some of the time. They all
have colors, just not the right ones. Some field values that are onl 884
are
red.

Any thoughts or suggestions are appreciated. Thanks in advance.
Click to expand...
Click to expand...
 
Back
Top