title: String Split on Line Break
body: <p>I have a textbox on a MS Access form that users are going to copy a column of numbers into from an excel spreadsheet.  I need to take this input and use it as parameters to build a query.  I have code that looks like this</p>
  
  <pre><code>Dim data as variant
  Dim input as String
  data = Split(input,vbLf)
  </code></pre>
  
  <p>I want to be able to build a list of the input from the users but I can't figure out how to split it on the line break.  I've tried "\n\r", "\n". "\r", vbCrLf, vbLf.  The input looks like "12345[][]23456" with the box characters between each number</p>
  
  <p>Thanks </p>