String Question

J

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
 
S

Steve Lang

Hi JF,

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


HTH and have a great day!

Steve
 
Top