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?