>I am trying to set the BackColor of a grid cell based on a calculated value (similar to FieldState). I currently have the calcualted values in an array with one element corresponding to each field in the cursor. My idea is to put a function in DynamicBackColor that uses the grid's X,Y position to refer back to the associated array. Is this feasible? If not, I am open to suggestions.
>
>TIA,
>Larry Long

Larry,
Why don't you do it in an easy way. Create a custom method to return the backcolor and set that custom method as the dynamicbackcolor's function. ie:

*Form.MyColor
lparameters tcControlsource
lnRecno = recno() && Y
if lower(justext(tcControlSource)) == 'myfield' && X
* You might get column index position into array from field()
* But keeping an array doesn't look very feasible thinking array limits
* if limits are OK would be fast
*....
return lnColorCode

*Grid.init && Or anywhere like a commandbuttonclick
with this
 for ix=1 to .Columncount
   .Columns(ix).DynamicBackColor = ;
     "(thisform.myColor('"+.Columns(ix).Controlsource+"'))"
 endfor
endwith

PS:You might also try varread() as the Y component.
Cetin