>FOR EACH loColumn IN this.Columns > lcCS = 'this.' + loColumn.Name + '.ControlSource' > IF TYPE(EVALUATE(lcCS)) = 'N' > loColumn.DynamicBackColor = [IIF(EVALUATE(] + lcCS + [) < 10, RGB(225, 128, 128), RGB(128,255,128))] > ENDIF >ENDFOR >>thanks
FOR EACH loColumn IN this.Columns lcCS = 'this.' + loColumn.Name + '.ControlSource' IF TYPE(lcCS) = 'N' loColumn.DynamicBackColor="IIF(EVALUATE('" + lcCS + "') < 10, RGB(225,128,128), RGB(128,255,128))" ENDIFI changed the [] to ", not because there's anything wrong with using [] as text delimiters, but because my eye sees them as array subscripts. This way was easier for me to read.