[Exasperated] you need to read the whole thread. You have not provided much information so these may or may not be viable for you
there may be others but at a glance
before inserting the contents to the destination excel spreadsheet be sure to format the cells first as “Text” instead of “General”. Then insert your copied contents and you will see all characters (>255) are preserved
If you are doing Totals and “grouping by” in your query, selecting “First” on the memo field instead of “group by” will allow you to export the full contents of the field.
Remove the “unique values” property in the query’s design. Apparent reason: Access cannot compare memo fields to one another to determine the uniqueness that you asked for; so it uses the first 256 or so characters to do the match, and in the process the whole field gets cut down to that size when exported.
I prefer to pull the data in from Excel (database query), which also retains the memo fields
And Ranman has offered another solution - which rather than just repeating your problem, think about what has been suggested i.e. change your query to a maketable query and export the table.