Continuous Form colors

[cl3093]

Can I change the backcolor of a row based upon its value like points = 75?

Thanks.

cl3093

[RuralGuy]

Look at Conditional Formatting.

[SteveH2508]

Try this out.

[cl3093]

Steve,

How do you change color in frmseveral, code or conditional format? I don't see any code behind it.

I tried to change color of my form by code and failed.

Thanks very much.

cl3093

[cl3093]

Rural,

I need to use a var as criteria like
Points = mycolor instead of a number

Thanks very much.

cl3093

[SteveH2508]

Steve,

How do you change color in frmseveral, code or conditional format? I don't see any code behind it.

I tried to change color of my form by code and failed.

Thanks very much.

cl3093

The bound object frame frbcolours displays the 1x1 coloured bitmap retrieved from tblColours by the recordsource query qryseveralcolours.

[cl3093]

is it possible using code to check the value of cell of a row and then change its backcolor according?

Thanks.

Charles

[RuralGuy]

Rural,
I need to use a var as criteria like
Points = mycolor instead of a number
Thanks very much.
cl3093

So the Points are *not* in a field in the RecordSource of the Form?

[cl3093]

My form has a sub form which is continuous form and gets data from query directly. One cell is price. I want to change the backcolor of price according to its value.

Thanks.

Charles