C
CSAngel
I am using Access 2007 and I am having a terrible time trying to get things
to work.
I have to combo boxes and a text box. I want the text box to change colour
based on the result of multiplying the combo box values like so:
combo 1 x combo 2 =
0 to 5: green
6 to 15 : yellow
16 to 25: red
What I did was create an OnChange event for the combo boxes that multiplies
their values and puts the result in the text box - that works awesome.
Then I set up conditional formatting for the text box using Value Is and
between x and y but it doesn't work. At first the colours were random
(didn't match the conditions ie: a value of 10 gave me a green box). Now I
don't get any colours. I have the enabled property set to true.
Has anyone else had issues like this?
I also tried using an expression to multiply the combo box values together
but that didn't work either.
Does the conditional format box generate VB code somewhere that I can debug?
Thanks!
Angel
to work.
I have to combo boxes and a text box. I want the text box to change colour
based on the result of multiplying the combo box values like so:
combo 1 x combo 2 =
0 to 5: green
6 to 15 : yellow
16 to 25: red
What I did was create an OnChange event for the combo boxes that multiplies
their values and puts the result in the text box - that works awesome.
Then I set up conditional formatting for the text box using Value Is and
between x and y but it doesn't work. At first the colours were random
(didn't match the conditions ie: a value of 10 gave me a green box). Now I
don't get any colours. I have the enabled property set to true.
Has anyone else had issues like this?
I also tried using an expression to multiply the combo box values together
but that didn't work either.
Does the conditional format box generate VB code somewhere that I can debug?
Thanks!
Angel