Hyperlinks and Exporting access reports to rtf / excel

[LarrySmithVA]

I have a table with fields of Title, Description, and URL. I have a report with a text box, IsHyperlink set to yes and Control Source set to =[Title] & "#" & [URL] & "#" . When I open the report in report view, it works great - the Title is displayed as a hyperlink and if I click it, I go to the URL. However, if I export the report to rtf or excel, I only get the Title - it is not a hyperlink. Any ideas on how to get the display text (Title) and hyperlink address (URL) from the access report to Word rtf and excel would be much appreciated.

[June7]

You are using the export wizard? Sorry, don't think any way to keep the hyperlink identity intact.

[LarrySmithVA]

Yes, using the export wizard. Funny thing, if I export to PDF - the display text and hyperlink address remain intact just as it is in the report.

[June7]

Then I qualify my statement: can't retain hyperlink identity in export to Word or Excel.