Member Avatar for guru511

hi
can u plz let me know how to delete msflexgrid rows which are empty

  • 3 Contributors
  • 2 Replies
  • 97 Views
  • 3 Years Discussion Span
  • Latest Post Latest Post by tjbvo
Member Avatar for QVeen72

Hi,

Check this Code:

Dim i As Integer
Dim j As Integer
Dim sSQL As String
For i= Grd.Rows-1 To 1 Step -1
  sSQL =""
  For j= 0 to Grd.Cols-1
     sSQL = sSQL & Trim(Grd.TextMatrix(i,j))
  NExt
  If Trim(sSQL) ="" Then
      Grd.RemoveItem i
  End if
  If Grd.rows<=1 Then Exit For
Next

Regards
Veena

Member Avatar for tjbvo

Hi Veena

Thanks. Your code works beautifully.

I just replaced "Gird" with my control name.

Julian

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.