conditional formatting fails at 3 digits+

[hehrerh]

I am trying to conditionally format some report fields to show which floor plans will fit, barely fit, barely do not fit, and do not fit on a given lot based on width and depth.

The rules I have applied function correctly until values meet or exceed 100 - after meeting or eclipsing this value the format seems to default to the format of my second rule: 'Value <= [Lot Width?]', when I would like it to display the dark red format of the fourth and final rule: 'Value > [Lot Width?]+3'.

All fields are the 'double' data type. [Lot Width?] and [Lot Depth?] are requested via pop-up box when the report opens and are not stored anywhere.

Thank you - the attached image shows my current formatting rules and the current results.

[RuralGuy]

What do you mean when you say "[Lot Width?] and [Lot Depth?] are requested via pop-up box when the report opens and are not stored anywhere." Where are they available?

[rpeare]

try

value < (cdbl([lot width?])-3)

if your lot width is not an integer

value < (cint([lot width?])-3)

if it is an integer

your conditional formatting may be reading it as a text value.

[hehrerh]

This fixed it! Thank you so much! It must be storing the value as text.

Is there a way to define Lot Width? as a double or integer on the report, so that I don't have to define it on each formatting line?

[rpeare]

On the report you can format your fields any way you want. You just might get #ERROR messages if you attempt to apply a numeric format to a text field (for example).