Passing string from Access 2003 to Word 2003 form

[jhawk]

I'm using an Access 2003 database to fill in a Word form document. I want to
pass a string that, when inserted into a Word formfield, can include carriage
returns.

The code:

strVerification = "3.a)1. Venting analysis. " & vbCrLf & _
"3.a)2. Review of Design. " & vbCrLf & _
"3.a)3. QA Inspection and certification of the as-built " & _
"hardware per approved design drawing. " & vbCrLf & vbCrLf

docWord.FormFields("bmkVerification3").Result = strVerification

The desired result:

3.a)1. Venting analysis.
3.a)2. Review of Design.
3.a)3. QA Inspection and certification of the as-built hardware per approved
design drawing.

And not :

3.a)1. Venting analysis. 3.a)2. Review of Design. 3.a)3. QA Inspection and
certification of the as-built hardware per approved design drawing.

The above code simply doesn't work. Is there any string of characters, that
when passed to Word as a string, can be interpreted by Word to mean a
carriage return? Or is there a way to have Word automatically run a macro to
replace a special character with a carriage return?

Any help would much appreciated.

 

[Alex Dybenko]

Hi,
AFAIR - it should be other character then vbCrLf, try vbCr, vbLF, chr(8) or
chr(7)

You can also put desired text into formfield and then read it content on VBA
to get exact character

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com