[Solved] Change control property based on SQL output

[1gatomontes]

I would like to have the property (background color) of a control (list box for example) change (upon form refresh) based on a number (ex: 1=red, 2=green, etc). This number is the result of a SQL snippet (which currently works) counting the number of rows in a table.

After looking for an easy solution, I'm now afraid that my only solution will be to turn to macros to do this, right? If so, any help would be appreciated, because macros is a very obscure world to me.

Thank you all!

[Villeroy]

Formatted controls behave like spreadsheet cells with numbers.

[BLUE][<0]#,0 "°C";[RED][>30]#,0 "°C";[BLACK]#,0 "°C"

[1gatomontes]

Thanks Villeroy, but this is too limited (up to 3 codes only) for our purpose, or am I getting the limitation wrong?

[Villeroy]

Yes. Seems to be so. A macro could do the trick for single controls. Nothing can not colour individual lines in a grid control.

[UnklDonald418]

I was recently working on a project that needed something similar to what you are asking so I put together a little demonstration of how a macro might work to solve your problem. The macro would probably need further massaging but at least it is a starting point.