Rich Text from MS Access 2007 to MS Word 2007 - TechRepublic
Question
July 22, 2008 at 06:35 AM
ictperson

Rich Text from MS Access 2007 to MS Word 2007

by ictperson . Updated 16 years, 5 months ago

Hi there,
I have a simple table with 3 columns in ms access 2007: EmpID (autonumber), EmpName (text, plain) and EmpBio (memo, rich text). I also have a word doc with two bookmarks for the EmpName and EmpBio. I want to copy data (while browsing the table-based form in access) to ms word doc. The Name field gets written correctly, but the biography turns into html tags.
I am using:
.Bookmarks(“bmBio”).Range.Text = Me.EmpBio
I know Range.FormattedText would work inside or between Word docs. But how do I make it work directly from ms Access using VBA?

This discussion is locked

All Comments