title: MS-Access 2007 - 255 character limit for exports and field concatenation
body: <p>When I create a new Access 2007 database, the memo fields only export the first 255 characters (to any file format - i.e. Excel, CSV, etc). </p>
  
  <p>When I concatenate fields (grouping and converting multiple rows to 1 with data summarized), it only concatenates the first 255 characters. 
  I am using a query and a Module to concatenate.</p>
  
  <p>Example:</p>
  
  <pre><code>User       Group
  User1        A
  User1        B
  User1        C
  </code></pre>
  
  <p>Concatenated to one row "User1", "A ; B ; C"</p>
  
  <p>If I use the same module, query and data created/imported into database created in a prior version (opened with 2007) I do not have this 255 character limitation with either the memo fields or the concatenation. Only on the newly created databases seem to have this restriction.</p>
  
  <p>Any ideas if this is a setting somewhere for newly created databases? </p>