DataGrid Highlight Problems

[Bill Crawley]

Hi All,

I'm using an ADO recordset to bind to a Datagrid (no problem there). The problem is when I do a find on the recordset, the recordselector moves to the correct record on the datagrid however the new row doesn't get highlighted. The original row is the one that stays highlighted. How can I get the new row to highlight. I've tried a refresh and I've tried forcing a click event, but it doesn't seem to work.

Regards
Bill Crawley

[Hack]

I've never worked with the DataGrid, but this is how I do it with the MSFlexGrid. Perhaps the code can be translated to fit your needs (at worst, your thread will get bumped up. Hopefully, someone will have a solution for the DataGrid.)

With MSFlexGrid1 
   .Row = 2 ' any row 
   .Col = 0 
   .ColSel = .Cols - 1 
End With 
End Sub