Loosing data when exporting

  • Thread starter Thread starter Talshiar
  • Start date Start date
T

Talshiar

I have set up a report to export data contained within
tables.
Say I have a product number and then a paragraph
describing that product. The description is there when I
look at it in access but when I export it to rtf and excel
it cut off the end of the description. I have looked for a
setting limiting it to 128 characters per field or
whatever but I don't see it. Anyone know how I may fix
this?
By the way: the data type is "memo" for the description.
Should it be set to text with a really large field size?
 
Talshiar said:
I have set up a report to export data contained within
tables.
Say I have a product number and then a paragraph
describing that product. The description is there when I
look at it in access but when I export it to rtf and excel
it cut off the end of the description. I have looked for a
setting limiting it to 128 characters per field or
whatever but I don't see it. Anyone know how I may fix
this?
By the way: the data type is "memo" for the description.
Should it be set to text with a really large field size?
Click to expand...


The export to RTF functionality in Access has *real* problems. It can be made
to "mostly" work for simple tabular data, but if you have memo fields (really
any controls that grow), then it is fairly common for text to be truncated.
Best to use the Snapshot format for exporting or perhaps merge to Word instead.
 
Back
Top