Missing text after export

[aaronjc]

When I export to Excel I find that there is text missing at the end. It is
there in "Query" but disapears when I export or copy and paste into Excel.
Thanks for the help.

 

[Jeanette Cunningham]

Hi,
fields with more than 225 characters can do this when exported.
Are you exporting a memo field?
How are you doing the export?
Are you using any calculated fields?

One workaround is to set up a table to use to export from.
Set up the table fields to match the fields from the query.
Instead of exporting the query, you append the query's records to the table
and export the table.
1. empty the table before you append the records you want to export from the
query
2. append the query data
3. export the table


Jeanette Cunningham -- Melbourne Victoria Australia