By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,221 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

Conditional Formatting / Calculated Field / Access2000 / Not Working

P: n/a
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?

Nov 15 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a

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 ???

Nov 15 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.