Min value w/conditional formatting

[Guest]

Hello,

I have a control "txtMin" in the header of a form and the continuous form
has a list of values ... I have conditional formatting setup to change the
background color of 'txtSOS" to blue if it matches the txtMin control. It
does not work. txtMin is setup to: Min([SOS]) and it reports the right
value but it just does not change color.. Am I missing something?

Thanks,
Ernst.

 

[Guest]

Are you using VBA because I think you are better off using the conditional
formatting?

format -> conditional formatting

 

[Guest]

That's what I'm doing...

Are you using VBA because I think you are better off using the conditional
formatting?

format -> conditional formatting

--

http://www.ready4mainstream.ny911truth.org/index.html

Hello,

I have a control "txtMin" in the header of a form and the continuous form
has a list of values ... I have conditional formatting setup to change the
background color of 'txtSOS" to blue if it matches the txtMin control. It
does not work. txtMin is setup to: Min([SOS]) and it reports the right
value but it just does not change color.. Am I missing something?

Thanks,
Ernst.

 

[Guest]

right!

I created a one-field table and entered a couple of dozen numbers.

All I did then was create a conditional format so that if the field is equal
to or greater than [txtmin] then turn the field blue and it works. Every time
the minimum is changed the field background is updated.

Works fine for me.

--

http://www.ready4mainstream.ny911truth.org/index.html

That's what I'm doing...

Are you using VBA because I think you are better off using the conditional
formatting?

format -> conditional formatting

--

http://www.ready4mainstream.ny911truth.org/index.html

Hello,

I have a control "txtMin" in the header of a form and the continuous form
has a list of values ... I have conditional formatting setup to change the
background color of 'txtSOS" to blue if it matches the txtMin control. It
does not work. txtMin is setup to: Min([SOS]) and it reports the right
value but it just does not change color.. Am I missing something?

Thanks,
Ernst.