putting html text in a report

[impulse24]

Hi,

I have a form where a user selects an employee, and then hits print. Reports are generated based on the employee query. I need to add banner text to the footer of each report. The banner text is on a web page. Is there a way to reference the url, and have the text appear on the page? I have tried using transfer text, and putting the html text into a temporary table with a memo field, and referencing the url, and access just consistently crashes. The text is not that long.

I have a text box at the bottom of the report, and I have used =hyperlink function, but that just displays the link. Please help.

 

[WildHare]

You may not know it, but there is an ActiveX "BrowserControl" that you can drop on a form or report. I think that might have the capabilities to do what you want, but you might consider the overhead of having to create a link to a URL every time a report is run. If the banner doesn't change a lot, you might import it as a picture and link or embed it as a picture object on your report. Lots less overhead.

Jim Jim Hare
"Remember, you're unique - just like everonone else"

http://www.jmhare.com