title: Formatting a recordset getString in a msgbox
body: <p>I'm using ADO to query a large table, and then put the recordset in to a String. The issue comes when I want to format that in a msgbox. My code looks like this:</p>
  
  <pre><code>Dim cn As ADODB.Connection
  Dim rs As ADODB.Recordset
  
  strFile = ThisWorkbook.FullName
  strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" &amp; strFile _
  &amp; ";Extended Properties=""Excel 12.0;HDR=Yes;IMEX=1"";"
  Set cn = CreateObject("ADODB.Connection")
  Set rs = CreateObject("ADODB.Recordset")
  
  cn.Open strCon
  rs.Open strSQL, cn
  strSQL = "SELECT Employee, Skill_Level FROM [Employee$] 'more specific SQL after this
  
  MsgBox "Employee/Skill Level" &amp; vbNewLine &amp; "-------------" &amp; vbNewLine &amp; rs.GetString, vbInformation, "Query Results"
  </code></pre>
  
  <p>When I do something like</p>
  
  <pre><code>dim blah As Variant
  blah = rs.GetString
  </code></pre>
  
  <p>and set a breakpoint and hover over 'blah' during runtime, I get something like 'LastName FirstName MI☐5LastName FirstName3☐' and so on. The message box actually gets displayed like this:</p>
  
  <pre><code>Employee / Skill Level
  ----------------------
  LastName FirstName MI     5
  ReallyLongLastName FirstName MI 3
  </code></pre>
  
  <p>It typically ends up looking ok, except in cases where last or first names are longer. My question is, what's the best way to format that GetString so that the skill level field matches up when I have really long names in the query result? </p>
  
  <p>Thanks for your suggestions!</p>