Prev: Help parsing HTML into text in my text box within my form
Next: Form using a query to look up values
From: chris23892 via AccessMonster.com on 29 Mar 2010 10:18
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 AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201003/1

From: chris23892 via AccessMonster.com on 29 Mar 2010 10:55
come on...I know someone out there has a solution somewhere :)

chris23892 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 AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201003/1

From: KARL DEWEY on 29 Mar 2010 17:22
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
>
> .
>
From: chris23892 via AccessMonster.com on 29 Mar 2010 20:53
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/Forums.aspx/access-forms/201003/1

From: Daniel Pineault on 30 Mar 2010 11:00
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/Forums.aspx/access-forms/201003/1
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: Help parsing HTML into text in my text box within my form
Next: Form using a query to look up values