Ian Chew ... Kevin Brown wrote:
>
> >Hi,
> >
> >I'm trying to do something that should be sooo simple (OK I'm a newbie as far as VFP is concerned, But I have had over 10 years Xbase experience).
> >
> >What I need is to be able to highlight an entire row of a grid not just the current cell. I tried listboxes but with 200,000 items they take a while to fill!
> >
> >Regards
> >
> >Kev
>
> Hi Kev
> I am also experiencing the same problem. I have a table with
> 400000 records and it does take a while to refresh. I use
> a grid as you did but I still prefer to use a listbox.
>
> Ian
use the Setall("DynamicBackColor",....) property
example to make the current row of a grid green while the rest are white:
1. create a form property "lnRecno"
2. in the AfterRowColChange() method put:
thisform.lnRecno = recno()
3. in the grid.init() method put:
this.setall("DynamicBackColor", ;
"IIF(RECNO()<>thisform.lnRecno, RGB(255,255,255) ;
, RGB(0,255,0))", "Column")
Note the currently selected cell will still be blue with white letters.
If you want the entire row to look the same as the selected cell
use 2 staments
1. this.setall("DynamicBackColor","iif(..., RGB(255,255,255), RGB(0,0,128))","Column")
AND
2. this.setall("DynamicForeColor","iif(..., RGB(0,0,0), RGB(255,255,255)","Column")
Bill
Bill Morris