String Question

[JF Bouthillier]

Hi all,

I have an MS Access DB that sends information to an MS
Word document. The information sent from the database is
a string and this string populates an MS Word cell in a
table.

How can I pass a "New Line" in the string so that it
appears on two distinct line? (as if I had pressed enter)

I tried passing Chr(10) within the string and it did not
work...

Thanks a lot.
JF

 

[Steve Lang]

Hi JF,

Try using the constant vbCrLf as in:
selection.typetext strText & vbCrLf & strText2


HTH and have a great day!

Steve