Conditional formatting error

[Meg]

I have a text box displaying the results of a calculation
[NetYield], and I wish to compare this result to the value
in a "benchmark" field [Text7].

I have applied conditional formatting to [NetYield], such
that if the answer is lower than the value in [text7],
then colour is green (OK), and if the answer is higher
then the field colour is red (warning).

Unfortunately Access sometimes gives the wrong formatting.
[text7]=3.5
when
[NetYield] = 10.7, colour is green
[NetYield] = 6.8, colour is red
both should be red.

[NetYield] and [text7] are both general number fields.

I am very confused!!
Thanks for your help!

 

[Newbie]

on what event have you placed the code?

 

[Damon Heron]

I assume you are using "Conditional Formatting" from the Format menu in
design view? It should work then. Two conditions - for text box "Net
Yield" - if fieldvalue is < than [text7] then green font - second
condition -if fieldvalue >[text7] then red font.
If not working, then when is the value entered in text7? or is this a
default value?

Damon