Greetings. I've run across an odd issue and I can't seem to figure out the problem. I have some text fields on a form. I've got their conditional format set to something like the following:

Value < 50; Red

Value => 50; Green

It works fine as long as the value is not >= 100. Anything higher makes the text red.  What the heck is going on?

Edit: Sort of answered my own question.  Access's conditional formatting sucks at typing.  I had to use [Expression Is] with CInt to get it to work correctly. *eyeroll*

• Edited by StormFX Saturday, August 15, 2015 2:58 AM

Text fields are sorted alphabetically even if its values look like numbers. "100" < "50" because "1" comes before "5". So the behavior that you experienced is entirely logical.

Thanks for the reply.  It does makes sense in that context. Though, it would be nice/make sense if the conditional formatting used the field's "Format" property to properly type-cast the value prior to formatting it.