Try this: one thing was you had unbalanced parens: only a right paren. You might need to ALLTRIM the controlsource.
for each oColumn in this.Columns
oColumn.DynamicBackColor=;
[thisform.mySetColor("]+oColumn.ControlSource+[")]
endfor
Another approach might be to pass the column number and have mySetColor look up the field from Grid.Columns(tnPassedColumnNumber)
>Hi all-
>
>I would like to set the DynamicBackColor property based on the name, not contents of a field. This passes the field contents (not the field name):
>(thanks to Cetin Basocz)
>
>for each oColumn in this.Columns
> oColumn.DynamicBackColor=;
> "thisform.mySetColor"+oColumn.ControlSource+")"
>endfor
>
>I have tried lots of combinations of quotes etc to attempt to pass the controlsource's field name to thisform.mySetColor, with no success. Any ideas?
>
>Carlie