title: Convert Column Type to Long Text in Access
body: <p>I am running a query in Access 2013.</p>
  
  <pre><code>SELECT short, long INTO newTbl
  FROM tbl
  </code></pre>
  
  <p>My problem is that long is a 1000 characters and by default newTbl treats it as Short Text. I can edit the field in Design View and change the type to Long Text, but when I rerun the query, it switches back to Short Text. Is there something I can add to my query so it automatically becomes Long Text?</p>