Soft Carriage Return

  • Thread starter Thread starter Scott
  • Start date Start date
S

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?
 
Scott said:
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?
Click to expand...


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.
 
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).
 
Neither Chr$(10) by itself or Chr$(13) by itself works. Thanks for trying
and I would appreciate any other ideas.

KARL DEWEY said:
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.


Scott said:
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?
Click to expand...
Click to expand...
 
Marshall Barton said:
Scott said:
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?
Click to expand...


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.
Click to expand...
It is Chr$(11). Got it from the Word side of the house.
 
Scott said:
Marshall Barton said:
Scott said:
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?
Click to expand...


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.
Click to expand...
It is Chr$(11). Got it from the Word side of the house.
Click to expand...


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