>Hi all-
>
>I have a grid created using crosstab. Each cell (not row) relates to a record in a separate table. I would like to base the cell color on the contents of the cell related record. What is the best way to do this?
>
>Carlie
Carlie,
If you can specify what color it would be in a method than use method.
In init of grid you would say :
for each oColumn in this.Columns
oColumn.DynamicBackColor = "thisform.mySetColor("+oColumn.Controlsource+")"
endfor
(Honestly I prefer grid custom method). In form's custom mySetColor you'd return suitable color.
This approach might be long if it's easy to directly define backcolor based on relations (ie: iif(Child.myField = blah blah...).
Cetin