Soft Carriage Return

[Scott]

I have a Word document that gets address data from a query in a database. If
the query has a hard return [Chr$(13) + Chr$(10)], the address does not line
up properly in the Word document. If I manually enter a soft return (Shift +
Enter) the address lines up properly. How can I put in a soft return in the
query?

 

[Marshall Barton]

I have a Word document that gets address data from a query in a database. If
the query has a hard return [Chr$(13) + Chr$(10)], the address does not line
up properly in the Word document. If I manually enter a soft return (Shift +
Enter) the address lines up properly. How can I put in a soft return in the
query?

You have to use Word's new line code. I don't know what
that is, but in Excel, it's just Chr(10), maybe it the same
in Word or maybe it's just Chr(13). Why they are different
in different parts of office is lost in the mists of time.

 

[Daryl S]

Scott -

Try just the line feed Chr$(10) without the carriage return Chr$(13).

 

[KARL DEWEY]

I do not know about your database but mine uses CTRL+Enter instead of
SHIFT+Enter.

I just checked ( Asc(Right(Left([MyField],2),1)) CTRL+Enter following
first character) and the character inserted is Chr(13).

 

[Scott]

Neither Chr$(10) by itself or Chr$(13) by itself works. Thanks for trying
and I would appreciate any other ideas.

I do not know about your database but mine uses CTRL+Enter instead of
SHIFT+Enter.

I just checked ( Asc(Right(Left([MyField],2),1)) CTRL+Enter following
first character) and the character inserted is Chr(13).


--
Build a little, test a little.

I have a Word document that gets address data from a query in a database. If
the query has a hard return [Chr$(13) + Chr$(10)], the address does not line
up properly in the Word document. If I manually enter a soft return (Shift +
Enter) the address lines up properly. How can I put in a soft return in the
query?

 

[Scott]

I have a Word document that gets address data from a query in a database. If
the query has a hard return [Chr$(13) + Chr$(10)], the address does not line
up properly in the Word document. If I manually enter a soft return (Shift +
Enter) the address lines up properly. How can I put in a soft return in the
query?

You have to use Word's new line code. I don't know what
that is, but in Excel, it's just Chr(10), maybe it the same
in Word or maybe it's just Chr(13). Why they are different
in different parts of office is lost in the mists of time.

It is Chr$(11). Got it from the Word side of the house.

 

[Marshall Barton]

I have a Word document that gets address data from a query in a database. If
the query has a hard return [Chr$(13) + Chr$(10)], the address does not line
up properly in the Word document. If I manually enter a soft return (Shift +
Enter) the address lines up properly. How can I put in a soft return in the
query?

You have to use Word's new line code. I don't know what
that is, but in Excel, it's just Chr(10), maybe it the same
in Word or maybe it's just Chr(13). Why they are different
in different parts of office is lost in the mists of time.

It is Chr$(11). Got it from the Word side of the house.

Well, I don't feel too bad about not guessing Word would use
Vertical Tab as the code for a new line ;-|