Conditional Formatting / Calculated Field / Access2000 / Not Working

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?

re: Conditional Formatting / Calculated Field / Access2000 / Not Working

The following selection had been made for the conditional
formatting and did not work!
(Field value is) * * (Greater Than) * *(2)

I changed the selection for conditional formatting for the same
textbox and this DID WORK!
(Expression is) ([txtShiftsMissed]>2)


This makes no sense to me at all. These options should both
evaluate the same, but they don't ???