title: How to store a String (length > 255) from a query?
body: <p>I'm using Access 2000 and I have a query like this:</p>
  
  <pre><code>SELECT function(field1) AS Results FROM mytable;
  </code></pre>
  
  <p>I need to export the results as a text file.</p>
  
  <p>The problem is: 
  <code>function(field1)</code> returns a fairly long string (more than 255 char) that cannot be entirely stored in the <code>Results</code> field created from this query.</p>
  
  <p>When i export this query as a text file, i can't see the string entirely. (truncated)</p>
  
  <p>Is it possible to cast <code>function(field1)</code> so it returns a <code>Memo</code> type field containing the string ?
  Something like this:</p>
  
  <pre><code>SELECT (MEMO)function(field1) AS Results FROM mytable;
  </code></pre>
  
  <p>Do you know others solutions?</p>