title: Listbox population sometimes shows number instead of text value
body: <p><a href="https://i.imgur.com/5IKD8r1.png" rel="nofollow noreferrer"><img src="https://i.imgur.com/5IKD8r1.png" alt=""></a>
  I have a listbox in a userform. I use a SQL query to pull data and then populate the listbox. When I look at the query in SQL, it is fine and shows text in those fields. The listbox is showing these numbers though, 4 and 5, what I am assuming is the column name or fields value?</p>
  
  <p>It should say "Landfill/Wellfield" and "O2 levels", so it is not a text length issue. This is all test data. The last column correctly shows "Sparkplugs/Ignition System"</p>
  
  <p>The listbox has 7 columns of data. </p>
  
  <p>Code for the listbox population:</p>
  
  <pre><code>lbx_SSM.Clear
  Do Until XL_RSet.EOF = True
      For i = 1 To 7
          If i = 1 Then
              lbx_SSM.AddItem (XL_RSet.Fields(columnName(i)))
          Else
              If Not (XL_RSet.Fields(columnName(i)) = "Null") 
                  Then lbx_SSM.List(lbx_SSM.ListCount - 1, i - 1) =(XL_RSet.Fields(columnName(i)))
              End If
      Next i
      XL_RSet.MoveNext
  Loop
  </code></pre>