Allan,

I tested a local view with my records in an unusual order (to get away from the natural table order) and the RECNO() is numbered sequentially.


>Hi.
>
>I'm sure you are all familiar with the SetAll example in the Help file
>
>frmMyForm.grdGrid1.SetAll("DynamicBackColor", "IIF(MOD(RECNO( ), 2)=0, RGB(255,255,255), RGB(0,255,0))", "Column") && Alternate white and green records
>
>but it doesn't work when you set an order to the table (obviously).
>
>Is there an alternative to using recno() when an order is set? It's such an obvious problem I can't believe that no-one has noticed it before.
>
>Any solution greatly received!
>
>Richard Owen - Kelworth Limited