Conditional formatting error

  • Thread starter Thread starter Meg
  • Start date Start date
M

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!
 
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
 
Sorry...got bogged down in a different problem for a few
days!

Yes, I am using conditional formatting from "Format" menu,
with 2 conditions - one for greater than, one for less
than or equal to [text7].

[Text7] has a control source "=3.5"
This is only because I am still in testing phase, and have
not yet set up the functionality to populate this field
with the actual numbers. It will eventuially be bound to
a table field.
I dont think that this should be the problem, because I am
using exactly the same setup for 5 other benchmarks, and
all are working as expected.

It all seems to me like it should work.
Maybe I have discovered a new 'feature'!!

Thanks,
Meg
-----Original Message-----
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


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!
Click to expand...


.
Click to expand...
 
Back
Top