Highlighting a search row in a MSHFlexGrid

Hi,
I am trying to assign a record found in a recordset to a MShFlexGrid so that it can display the entire row when a name is seached. I am finding difficulties to assign the property of the MSHFlexGrid that will highlight the row. Here is the code I am using. Any help would be much appreciated. Thanks

Albert

If rsData.EOF Then
MsgBox "Couldn't find the Name"
Else

MSHFlexGrid1. = rsData.Fields.("Lastname").Value

End If

[Clunietp]

Hi Albert


Dim i As Integer

With MSFlexGrid1

.Col = 0
.Row = 2 'assuming we found match in row 2

For i = 0 To .Cols - 1
.ColSel = i
Next i
End With