Stripping HTML Tags out of a Text record

  • Thread starter Thread starter Tom Olsen
  • Start date Start date
T

Tom Olsen

All,

I have to strip away all HTML tags that will appear embedded in each
record.
Basically, I have to write something that would delete anything between <
and > including the sign. So all the <bold> and <Body> and the rest of the
tags have to be deleted,
Access 2003.

Thanks in advance..

Tom
 
I answered your post int he original thread yesterday.
From: Stephen Lebans
([email protected])
Subject: Re: I have to strip HTML tags out of a line of text


View this article only
Newsgroups: microsoft.public.access.modulesdaovba
Date: 2004-11-02 16:22:06 PST


While there is probably code out ther in VB land to act as an HTML to
Text parser there may be a couple of simpler solutions.

1) Embedd the MS Internet Explorer ActiveX control on a hidden form.
Copy your HTML string to the control then read the control's text
property. To get you started see:
http://www.lebans.com/htmleditor.htm

or

2) Copy the HTML text to the ClipBoard. Then ask the Clipboard for plain
text. You will have to search for VB API clipboard routines as Access
does not expose a ClipBoard object.




--

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