Access 2000
Using a textbox of a single form, I created a calculated field. The
following code is in the Control Source for this field:
=IIf([SHIFTHRS]=24,[intShiftsMissed]+([ADJUST]/[SHIFTHRS]),[ADJUST]/
[SHIFTHRS])
The numbers that are calculated are correct, and is working fine.
Using Conditional Formatting for this textbox, I attempt to change the
background color to red whenever the resulting number is greater than
2.
The following selections were made for the conditional formatting:
(Field value is) (Greater Than) (2)
Most of the time this works. But for some reason, some record fields
are not turning red despite the number in the field being greater than
2. I took measure to test the displayed number, and it is greater
than 2, but the conditional formatting is not recognizing this, since
it does not turn the textbox red.
Any ideas?