I
ictperson
I have a simple table with 3 columns in ms access 2007: EmpID (autonumber),
EmpName (plain text) 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 form has the
memo bound field as rich text and is displayed as such. When I open the doc
in VBA and write the 2 fields to it, the Name field gets written correctly,
but the biography has html tags like div, em, strong ... etc along with the
text.
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? I need to keep the
formatting in Word (can't use PlainText()). TIA.
EmpName (plain text) 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 form has the
memo bound field as rich text and is displayed as such. When I open the doc
in VBA and write the 2 fields to it, the Name field gets written correctly,
but the biography has html tags like div, em, strong ... etc along with the
text.
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? I need to keep the
formatting in Word (can't use PlainText()). TIA.