Help parsing HTML into text in my text box within my form

Here's an interesting problem I hope someone can help with.

I am pulling in data that is displayed in one of my text boxes (set up as
memo format). the data used to be in plain text from the SQL server we are
pulling from.

Well now, we just had to change things...Now the data pulled for this text
field comes in the format of HTML and now it is displayed in my text feild in
my Form as garbled, HTML

How can I parse this to plain text? I have no control over the format in
which the data is stored on the SQL server we are pulling this information
from.

There has to be a way I can convert the HTML to plain text and have this
displayed correctly in my text box in my form.

Suggestions??

--
Message posted via http://www.accessmonster.com

Can you push it out to Excel, copy, and Paste Special - Text, and then back
into Access?

--
Build a little, test a little.


"chris23892 via AccessMonster.com" wrote:

Here's an interesting problem I hope someone can help with.

I am pulling in data that is displayed in one of my text boxes (set up as
memo format). the data used to be in plain text from the SQL server we are
pulling from.

Well now, we just had to change things...Now the data pulled for this text
field comes in the format of HTML and now it is displayed in my text feild in
my Form as garbled, HTML

How can I parse this to plain text? I have no control over the format in
which the data is stored on the SQL server we are pulling this information
from.

There has to be a way I can convert the HTML to plain text and have this
displayed correctly in my text box in my form.

Suggestions??

--
Message posted via http://www.accessmonster.com

.

Not realistic for over 10,000 records. There has to be a VB script somewhere
that can parse HTML into text so it will display right in the text box in my
form.

KARL DEWEY wrote:
Can you push it out to Excel, copy, and Paste Special - Text, and then back
into Access?

Here's an interesting problem I hope someone can help with.

[quoted text clipped - 14 lines]

Suggestions??

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201003/1

you could use a web browser call to extract the innerHTML or something along
those lines.

see
http://www.tek-tips.com/viewthread.cfm?qid=1458220
http://www.pcreview.co.uk/forums/thread-947224.php
http://www.ozgrid.com/forum/showthread.php?t=91644

To give you some inspiration. You should be able to modify the sample code
to suit your needs.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"chris23892 via AccessMonster.com" wrote:

Not realistic for over 10,000 records. There has to be a VB script somewhere
that can parse HTML into text so it will display right in the text box in my
form.

KARL DEWEY wrote:
Can you push it out to Excel, copy, and Paste Special - Text, and then back
into Access?

Here's an interesting problem I hope someone can help with.

[quoted text clipped - 14 lines]

Suggestions??

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201003/1

.