Viewing HTML fields

[John Robert]

We are interfacing with an SQL field that is HTML formatted. Is there a way
to have the Access form field show the text without the HTML controls?

 

[TC]

No way using a normal Access control like a textbox - unless you write the
code to parse the HTML yourself - and you really do not want to do that!

You need some kind of "HTML viewer" control. I know that the MS Web Browser
control works in Access. Perhaps you could save the content of the SQL field
into a temporary disk file, then display that file using the .Navigate
method of the web browser control? Search the web for "webbrowser control"
for more information on that control.

If there are other ways of doing this, I'd be interested to hear of them.

HTH,
TC

 

[Stephen Lebans]

See:
http://www.lebans.com/htmleditor.htm
A2KSHTML.zip is an HTML Editor built around the MS Web Browser control.

--

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

 

[John Robert]

Dear Stephen:

Thanks for the help. This is truly superb. I still have a problem though.
I want to generate a report using forms and then print them to send or email
to an associate. Is there a way to automatically have the field convert
from HTML to a viewable type of field (say if we have 20 contact records
that each have this field?)....Thanks for any suggestions.

John