Im using the code below to populate an MSHFlexgrid, but when I go to click on a record in the mshflexgrid sometimes I need to click a line below the record I actually want to select...

ie....
row1
row2
row3
blank space

sometimes to select the data in row 3 i need to click the blank space, and to select row 2 i need to select row 3....

Any ideas? I tried adding a .refresh after the data was loaded but that doesnt seem to help. (or maybe i have the refresh in the wrong place.

VB Code:
  1. Dim sconnect As String
  2.     Dim sSQL As String
  3.     Dim dfwConn As adodb.Connection
  4.     Dim datPrimaryRs As New adodb.Recordset
  5.     Dim ConnectNames
  6.    
  7.     ' set strings
  8.     sconnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + path + "';Persist Security Info=False"
  9.     sSQL = "select id, LastName, FirstName, Address, Relationship from Record where LastName like '" & Text9.Text & "' order by LastName, FirstName ASC"
  10.  
  11.    ' open connection
  12.     Set dfwConn = New adodb.Connection
  13.     dfwConn.Open sconnect
  14.    
  15.     ' create a recordset using the provided collection
  16.     datPrimaryRs.CursorLocation = adUseClient
  17.     datPrimaryRs.Open sSQL, dfwConn, adOpenForwardOnly, adLockReadOnly
  18.    
  19.     Set MSHFlexGrid1.DataSource = datPrimaryRs