Hi!

Yes, there is a way to refresh the back color of the line without call of the Grid.Refresh, but the approach is somewhat complex and is not tested in the live environment in production. If you want, I can describe it, but it has also disadvantage - while speed of rows refreshing is better when you navigate them, as soon as the entire grid is refreshed, it bocemes slightly slower than with usuall approach. This is because you will need to use custom method call from DynamicBackColor expression instead of using iif() function. The slow down is little, however, compare to how it could be slow when refreshing the entire grid with filtered recordset.

You're right, it is better to use views instead of filtered table.

If you want, I can look to your code and tell you which parts cause slow down and how to change them to speed up the forms.


>hi all,
>
>filtering the table on a grid would slower the process, switching to views instead of tables makes it better. But then, I have to put a dynamicbackcolor on the afterrowcolchange event to give the users a "listbox feel".
>
>This makes the program very slow, the refresh rate is very significant. Is it possible to change the backcolor of 2 rows (jumping from 1 row to another), without refreshing the whole grid? Or are there any other way to set the color in a faster way?
>
>sigh, always have speeding problems in my program :-\
>
>Thanks in advance!
>Jimi