Q: Dawn Crosier writes: I read through your “Access 2007 VBA For Data-Centric Microsoft Office Applications” and have questions about how to get formatted text out of the Access database into a Word Bookmark without bringing all the HTML code.
A: I did some experimentation, using my Rich Text Demo sample database from Access Archon #157. I found that the plain text could be extracted from rich text in an Access control using the wdFormatPlainText named constant. Here is code for a command button Click event that puts the plain text from a Rich Text control into a new Word document (it could also be written to a bookmark or doc property):
Private Sub cmdPastePlainTexttoWord_Click()
On Error GoTo ErrorHandler
Dim strRichText As String
Dim appWord As Word.Application
Dim doc As Word.Document
Set appWord = GetObject(, "Word.Application")
Set doc = appWord.Documents.Add
If Err = 429 Then
Set appWord = CreateObject("Word.Application")
MsgBox "Error No: " & Err.Number & "; Description: " _
Article posted: Tuesday, 09 December 2008
there's more ...
If you liked this article you'll LOVE our new ebooks.
Windows 8 for Microsoft Office users A practical guide the new, changed and unfamiliar in Windows 8
A focused and unvarnished look at Windows 8, especially written for
the many people who use Microsoft Office Get it today
- click here.
ORGANIZING OUTLOOK EMAIL - tame your Outlook 2010 Inbox
100+ pages of practical tips and help to streamline,
automate and search your Inbox. Get more
than you ever thought possible from Outlook. Read it today
- click here.