Web Development

Ask something
Discussion Locked

Exporting Access report to RTF

0 helpful
3 replies

by ati

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi There
I have an access report which works perfectly in access, but if i export it to RTF it cuts off the end of some of my report fields. if i export the report to snapshot it works fine but not RTF and i need to be able so people can view my report in word.

Thanks
Scott

3 replies

by michal.woznicki

Can you try this...

Open the Report in Preview
Click on 'Tools', 'Office Links' and then 'Publish with MS Word' this will create a RTF export of your Report.

If this has truncated some of your fields then you are not going to have any luck unless you are prepared to keep playing with the format of the access report so that it creates a better export to RTF i.e. Reducing Font Size and increasing the length of the fields being truncated. Because the export routine is pre-defined by Microsoft there is nothing else to play with.

There are known issues with lines being removed and formatting of long strings and memo fields being incorrect.

You could try Mail Merge to Word using code if Word is the Output required or PDF for accurate representation of the Access Report.

by ati

I didn't manage with that approch, what i had to do in the end was write to the word document straight from visual basic using bookmarks!

This discussion is closed to new replies.