>Dear Experts
>
>There is a variable nvalue=30 and grid has three columns. One columm has values as
>
>30
>25
>30
>30
>22
>30
>
>I want values less than variable value ,30, with RED Forecolor.
>The Forecolor of other values will be Blue.
>
>Please help
FOR EACH oColumn IN thisform.Grid1.Column
oColumn.DynamicForeColor = "IIF("+oColumn.ControlSource+" < m.lnValue, RGB(255,0,0), RGB(0,0,255))"
ENDFOR
(not tested)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.