Gustav Brock
Gustav at cactus.dk
Wed Jun 10 03:37:54 CDT 2009
Hi John You are probably receiving a LF or a CR only and not a CR+LF which is a new line in VBA. Try running Replace on the string: Replace(strMemo, vbCr, vbCrLf) or: Replace(strMemo, vbLf, vbCrLf) /gustav >>> Johncliviger at aol.com 10-06-2009 10:29 >>> Hi All I have a protected Word doc with 20 or so bookmarks. And in Access I use vba to import the each bookmark contents to a Access table. It works well, but for a small irritation. In the memo field I get a small square at the end of each sentence. I guess its a paragraph marker from Word. Anyone know what causes this and how to remove them? In Access I use the code '!CaseSummary = Doc.formfields("BookmarkName").result' to populate the table TIA johnc