ADO recordset: Convert RTF field into plain text

arno

Guest

Posts: n/a

23rd Apr 2008

Hello,

somewhere I read that in VBA you can convert an RTF field into plain text
with eg.

myfield = PlainText(rtf_field)

which will remove all formats, tags etc. from the rich text and show the
plain text only. Is there a way to do this in Excel-VBA when using an ADO
recordset?

regards

arno

« Remove end folder from path found with ThisWorkbook.Path command ? | Copying cells from one worksheet to another, within the same workbook »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Convert ALL fields to plain text?	Stefan Blom	Microsoft Word New Users	0	21st May 2011 07:06 PM
convert rtf to plain text	tinique	Microsoft Access ADP SQL Server	1	12th Sep 2007 06:13 PM
How should I convert Rtf to plain text?	=?Utf-8?B?UElFQkFMRA==?=	Microsoft Dot NET Framework	3	27th Jun 2006 03:35 PM
Convert Outlook Rich Text to Plain Text	=?Utf-8?B?UkFK?=	Microsoft Windows 2000 Group Policy	2	25th Mar 2005 05:31 PM
How to convert recordset of only PKs into full field recordset?	Bam Bam	Microsoft Access	3	4th Oct 2004 04:04 AM