>I'm wondering why my grid slows down so much when i'm using dynamic back color
>
>Here is what I'm using:
>
>this.grid1.SetAll("DynamicBackColor","iif(gridfile.selected,thisform.SelectedColor,thisform.UnSelectedColor)", "Column")
>
>If I comment out this code the grid runs a LOT more quickly.
>
>Any idea how to speed things up?
>
>Thanks,
>
>scott
Scott,
With dynamicbackcolor grid doesn't have a noticable slow down. Are thisform.un/selectedcolor properties or methods ? Or is there any other method running in between to set gridfile.selected ? Try with an expression like :
iif(.t.,rgb(255,255,0),rgb(255,255,255))
with methods in between disabled to see if it's really DynBkClr slowing down. Grid DynBkClr is only evaluated for visible part (it doesn't make difference that you have 100 or 50000 recs).
Cetin