title: vba string max size
body: <p>is there a limit in vba string variable?</p>
  
  <pre><code>Public query As String
  query="select * from ......"
  </code></pre>
  
  <p>i type a query that's very long and at a certain point it just stop, i can't type anything more in the quotes
  i tried to copy paste my query from notepad but the query is being split to new line</p>
  
  <p>i tried to print the length it's stop at 1005</p>
  
  <pre><code>len(query)
  </code></pre>
  
  <p>if there really is a limit in vba string
  how should i do a very long string then?</p>