>Can anyone give me a lead on how to alternate two colors in the rows of a grid, so it looks like the old style green-lined printer paper?
In Thread #
401746 Message #
402538 Mike said the following:
< Mike >
Yep, there's a solution kicking around, try this:
* Grid.init
select recno() ;
from (this.recordsource) ;
order by myOrder ;
into array ;
thisform.aOrder && A form or grid custom array property
this.setall("DynamicBackColor",;
"iif(ascan(thisform.aOrder,"+;
"recno())%2=0,rgb(0,255,0),rgb(255,255,0))","Column")
< /Mike >
You can also set the recordsource to a view sorted in the right order and look at even recno()'s.