Hello All,
I've seen several posts online similar to this question but none have given me the answer I am looking for. I need to create an Access Report that also renders HTML tags that are stored in various fields. We have a form online that uses FCK editor for certain fields to allow users to format their texts - sort of like MS Word. The formats are saved as HTML in each relevant field. We then import the data from the web to a local A2K table to be used to create a report.
A sample of the data stored in one of the fields is as follows. Keep in mind that there are other fields that have similar data.
========================
<ol>
<li>Senior Clinical Researcher, <br />
Division of Head & Neck Oncology (Since 2008)</li>
<li>Senior Clinical Researcher, <br />
Department of Biological Therapy (Translational Research) (Since 2008)<br />
<span style="font-size: 12pt; font-family: Arial; ">N. N. Blokhin Russian Cancer Research Center (NNBRCRC) affiliated to Russian Academy of Medical Sciences, Russian Federation <br type="_moz" />
</span></li>
<li><span style="mso-bidi-font-size:
9.0pt;font-family:Arial;ms
o-bidi-fon
t-family:A
rial;font-
weight:nor
mal;
mso-bidi-font-weight:bold"
>Program Coordinator, <br />
<o:p><span style="font-size: 12pt; font-family: Arial; ">European School of Oncology (Russia-CIS)</span> &
nbsp;(Sinc
e 2007)</o:p></span></li>
</ol>
<p><!--StartFragment--></p
>
<p class="MsoTitle" align="right" style="text-align:right"><
!--StartFr
agment--> <!--EndFragment--></p>
<!--EndFragment-->
<p> </p>
==========================
===
Is it all possible to create a report that "renders" the html in each field?
If yes, does anyone know of codes / active x controls that can render the html tags in the report?
NOTE: We do not want to parse out the html tags; there are various examples of how to get raw text by parsing out the html tags. But this is not what we want - we can to keep the formats in the reports.
Start Free Trial
