title: VBA Multiline String Issues
body: <p>I am not having much experience writing VBA script, I am almost lost to find out in the multiline string. Where exactly I am lost is when I try to split the String in multiple lines, could you help me how to end </p>
  
  <p>Working String is below before split:</p>
  
  <pre><code>strSQL = "insert into ded_limit_analysis (PDPD_ID,PDDS_DESC,PRODUCT_CAT,BASE_PDPD_ID,PROD_CYCLE,HMO_IND_DED) " &amp; vbCrLf &amp; _
   "values (" &amp; "'" &amp; Me.txt_pdpd_id &amp; "'" &amp; "," &amp; "'" &amp; Me.txt_pdds &amp; "'" &amp; "," &amp; "'" &amp; Me.cbx_prod_type &amp; "'" &amp; "," &amp; "'" &amp; Me.txt_base_pdpd &amp; "'" &amp; "," &amp; "'" &amp; Me.cbx_prod_cycle &amp; "'" &amp; "," &amp; "'" &amp; Me.txt_hmo_ind_ded &amp; "'" &amp; ")"
  </code></pre>
  
  <p>The one not working is below, I am trying to split the lines because I have many columns to include in insert and it is more than 1000 caracters and not able to fit in single line (below is just sample, actual is much longer and I am forced to split the lines).</p>
  
  <pre><code>strSQL = "insert into ded_limit_analysis (PDPD_ID,PDDS_DESC,PRODUCT_CAT,BASE_PDPD_ID,PROD_CYCLE,HMO_IND_DED) " &amp; vbCrLf &amp; _
   "values (" &amp; "'" &amp; Me.txt_pdpd_id &amp; "'" &amp; "," &amp; "'" &amp; Me.txt_pdds &amp; "'" &amp; "," &amp; "'" &amp; Me.cbx_prod_type &amp; "'" &amp; "," &amp; "'" &amp; Me.txt_base_pdpd &amp; "'" &amp; "," &amp; "'" &amp; Me.cbx_prod_cycle &amp; "'" &amp; "," &amp; " &amp; vbCrLf &amp;" _
   &amp; "'" &amp; Me.txt_hmo_ind_ded &amp; "'" &amp; ")"
  </code></pre>
  
  <p>Please advice where I am messing up, thanks</p>