VIEW HTML DATA IN AN ACCESS REPORT

[Phil]

I am using Access 2003 to LINK to an SQL database that I only have read
access to.

I am trying to create a report. Some of the fields in the rerport are memo
fields with html tags.

I would like for my reports to show the data with the html tags applied.
For instance, if the value in the field is <font color=red>red Text</font> I
would like the words red Text to appear in the report in red. But I can not
use the Bound
HTML control in the design of a report. Is there anything I can do?

I have looked at the html editor on lebans.com but I do not understand it
and do not believe I can use it since I am wanting to produce a report rather
than a data access page.

 

[Stephen Lebans]

There is no method to output HTML directly within an Access report.

The HTML Editor on my site is for standard Acccess FORMS only!( I don't know
why you think it is for DAPs)

If you must integrate HTML within your report then your best bet would be to
find an HTML to RTF converter that you could use at runtime. I'm sure this
solution is out there but I have not seen it myself. Perhaps you could
Automate an Office App that can load HTML and save as RTF.

The next version of Office is supposed to fix this issue once and for all.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.