RTF to Text

[someone]

I have thousands of rows data within an odbc.connectioned.database.
One of the columns in a certain table is blob type and contains RTF
formatted text.
Access 2000 sees this blob field as a memo type over the odbc connection and
reveals the contents as text surrounded by RTF markups.
These rtf texts are not lengthy - no more than 200 real characters and I
want to retrieve and store just the plain text without the RTF formating.
Some advise outputting to filename(s).txt but there's thousands of database
rows and this is not the answer.
I want to store the text equivalents in a localaccess.mdb

Any ideas?
..

 

[Autodidact]

What is known about Broadview?

 

[Tom van Stiphout]

On Sun, 18 Nov 2007 13:53:26 -0000, "someone" <[email protected]>
wrote:

Access' text control doesn't know about RTF. Use an RTF control to
display the data. Here is one: http://www.lebans.com/richtext.htm.

-Tom.

 

[someone]

Thank you Tom for the steer towards lebans web site.
The site in general and especially the RTF control are interesting and the
latter seems to have possibilities.
I can manually copy and paste from RTF to text field with it - any ideas
how to automate the migration of one table of RTF to another table of plain
text, using code or query? I think lebans has a const called Plaintext but I
can't work out how to use it.

Thanks

-someone

 

[Stephen Lebans]

Place an RTF2 control on a form and bind its source to the table/field in
question containing the RTF encoded text. Loop through all of the records
and simply copy the PlainText property(String) to the Memo field of the
second table.
--

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

 

[someone]

Now I've got it!
I must have missed the magic words "PlainText property" in your code/docs.

Thank you Stephen for your guidance.

-someone


"Stephen Lebans" wrote