title: VBA String Limit
body: <p>I've been working in Visual Basic for Applications (VBA) in Microstation V8i SS2, and I'm getting an Overflow error for my String value.</p>
  
  <p>It seems there is a limit in VBA for String values. The limit seems to be 255 characters. Reading up on it, a lot of sources says it can support up to 2 billion characters. This is not true?</p>
  
  <p>What happens is, I'm using ADO to interact with the database, so I'm building my own SQL INSERT statement inside the VBA. The INSERT statement gets long, like 300+ characters, depending on the 'Comments' column that accepts a multi-line text value.</p>
  
  <p>Anybody have a solution? Should I write my own COM-Addin from a .NET point of view, that gets referenced in the VBA?</p>
  
  <p><img src="https://i.stack.imgur.com/kplUP.png" alt="MsgBox Len(ssql)"></p>
  
  <p><img src="https://i.stack.imgur.com/gsPa7.png" alt="Visual Basic Break"></p>
  
  <p><img src="https://i.stack.imgur.com/v2wgg.png" alt="Error handler result"></p>