>Hi. I am trying to conditionally set colors in an option box text. For example, RED if out of stock.
>
>I put the following code in the option1.backcolor property (as a test)
>
>=IIF(crsQuoteList.qtynew<=0,255,0)
>
>Thanks, Randy
I suppose that is the correct approach. However, setting this in the properties window would have it evaluated only once, when the form starts. You'll have to recalculate the color, for example, in the object's Refresh() event, or when changing records.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)