Odd Issue with Conditional Formating in Access

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 4 hours 34 minutes ago
August 14th, 2015 7:57pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics