title: Microsoft Access 2007 with VBA - Parse Textbox, vbCrLf delimited
body: <p>Through some cruel twist of fate I have landed a job maintaining a system built entirely on Microsoft Access 2007.</p>
  
  <p>Anyway, I have a TextBox on a Form. I want to parse the contents of this TextBox. I want to declare two strings, have string one equal to the first line of the TextBox, string two equal to the second line and so on.</p>
  
  <p>I think I need to something similiar to below but I can't quite get my head around it.</p>
  
  <p>Thanks</p>
  
  <p>John</p>
  
  <pre><code>Dim stringOne As String
  Dim stringTwo As String
  
  Dim contentsOfTextBox As Array
  
  contentsOfTextBox = Split("txtMyTextBox.Text", "vbCrLf")
  
  stringOne = contentsOfTextBox[0].Text
  stringTwo = contentsOfTextBox[1].Text
  </code></pre>