numbers and conditional formatting.

[kallen via AccessMonster.com]

I have three fields. [minimum], [maximum], and [results]. They hold text
and numbers. I am using conditional formatting to make the [results] textbox
to turn red if the [results] are less than the [minimum] or greater than
[maximum] Here is my problem.

if minimum = 3.5, and results = 4.0 and maximum = 14.0 then the [results]
textbox turns red. if I add a zero to the minimum and results as this: 03.5,
04.0 then the red goes away. The only thing is, I don't want to add the
zero's manually and I cannot have the fronting zero's show up on a report.
They also have to be text boxes because sometimes a "passes test" is the
result. any help would be most appreciated.

Best Regards,

Kevin

 

[CurtainMary]

Hi, the way I would approach this is by temporarily turning the characters
into numbers using the VAL function.
CurtainMary

 

[kallen via AccessMonster.com]

Thanks Mary,

I just got finished adding the Val function and it worked almost perfectly.
It does not work for negative values. I worked around that by adding an
additional conditional format for negative values.

Thank you for responding!!

 

[CurtainMary]

Glad to be of help