Truncation of memo field in Access 2010 query
Posted on 2014-11-13
When I run a select query in Access 2010 the output for a memo field truncates at 255 characters. I'm guessing this is normal based on various sources. My query does not contain any aggregate functions (no group by and no expressions). The property settings for the query are all blank so nothing appears to be suspect there. The problem is the output results need to be exported to Excel, and since the memo column is not fully populated in the query, the result in Excel is also incomplete.
If I change my query to create a table and export or copy that to Excel, the problem does not exist. However, for certain projects this means having to create multiple temporary tables and then deleting them. If someone can suggest a way to modifying the query to have the full contents of the memo field appear, if possible, that would save some time and be much appreciated.