Maintaining Hyperlinks in Access Report when converting to HTML

[rewdee]

I have a report that has a field for hyperlinks. The report is fine but I want to convert to HTML using DoCmd.OutputTo. When I convert the report to HTML, the hyperlinks are displayed but have no HREF. The HTML in the report looks like:

<a HREF>./queryDetails/ESDailyAirWater_Q.html

Of course I want the HTML to look like:

<a HREF=&quot;./queryDetails/ESDailyAirWater_Q.html&quot;>ESDailyAirWater_Q.html</a>

Is there something I can do that will allow me to convert the report to html but maintain the links?

Any help or ideas would be appreciated.

Thanks,
Rewdee

 

[Databaseguy]

Just as with exporting to RTF, with HTML you lose a lot of the formattng.

I would suggest learning ASP. I do exactly what you are after currently using ASP, IIS and an intranet. Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[rewdee]

Rats and DOUBLE RATS. I do know ASP and other dynamic web pages (ISAPI,CGI) but the trouble is the server that I will get will not have scripts enabled so I must generate literally hundreds of static html pages. I originally okayed this because I thought:

1) the content of the pages would remain static
2) Make reports and have Access convert to HTML.

I'll have to write my own HTML report generator (File I/O).

Thanks for the reply,
Rewdee