Text truncated in report

[Dembrey]

Hi all,

I'm doing an export of a report to a text file using "DoCmd.OutputTo" command. When I do a preview of the report in Access everything appears OK.

However after the export to the .txt file some of the text just vanishes. Not only are some of the fields truncated but also in some fields its the inital characters that have disappeared and the end of the text string is OK.

All the textboxes are set with Can Grow=Yes.
(setting Can Shrink=Yes seems to make the problem worse, so its set to No.)

I've played about with the 'default' textbox height and also the font size in the design view, which has the effect of changing which fields get truncated in the outputted file, but doesn't solve it.

The effect doesn't seem related to field size either.

I'm using Access97 (under XP). Does anyone know if this is a known problem with Access, what I maybe doing wrong, any workarounds, ....?

Thanks for any help.

 

[IMO]

Try exporting the query or table the report is based on rather than the report itself.

IMO

 

[Dembrey]

IMO,

Thanks for the reply.

Unfortunately I'm exporting the report to create a (nicely) formatted html document.

I've tried using the export as html option of the outputto command but it failed miserably with the formatting, so I've settle on 'hardcoding' the html tags I need in the report and saving the resulting text file with a .html extension.

The report is quite complex both in its layout and the structure (pulling data from may tables and with several subreports etc.).

It works fine apart from this problem of lost/truncated text.

Cheers.