Conditional Formatting

[Paul]

I'm trying to use a simple "less than" condition, but
Access keeps interpreting the comparison field as a text
string instead of a number, causing strange results; e.g.
5>11
Any quick solutions? (I want to avoid assigning leading
zeros if possible)

 

[GVaught]

First of all less than is < not >.
Conditional formatting is based on a fields value. If you have a totals
field called total and you want all totals > than 500 to be red, then you
set the formatting of that field to red. Such as:
Field Value Is greater than 500; then select the color blue from the 'A'
drop-down.

 

[Guest]

Yup, I understand that...basically, what I was trying to
say in the previous example was that even though 5<11 is
clearly true, Access treats this as false, since 5>1 (i.e.
the first digit of the "string") even though all relevant
fields are purely numeric.