C
CEL
How can I insert a newline in concatinated text strings?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeff Boyce
If you are working in VB code, use the vbCRLF (carriage return, line feed).
If you are working in a query, you might need to use Chr(10) & Chr(13) (I
think I got those pesky ASCIIs correct...<g>)
Good luck
Jeff Boyce
<Access MVP>
If you are working in a query, you might need to use Chr(10) & Chr(13) (I
think I got those pesky ASCIIs correct...<g>)
Good luck
Jeff Boyce
<Access MVP>
C
CEL
Thanks for your reply - unfortunately I had already tried
the chrs - and just got a square box in the report. I'm
trying to concatinate an address into a field on the
report. Any other suggestions?
the chrs - and just got a square box in the report. I'm
trying to concatinate an address into a field on the
report. Any other suggestions?
D
Duane Hookom
Since Mr. Boyce is out of town, I will suggest using Chr(13) & Chr(10). It
must be in this order.
must be in this order.
C
CEL
Brilliant - it works! Many thanks.
-----Original Message-----
Since Mr. Boyce is out of town, I will suggest using Chr (13) & Chr(10). It
must be in this order.
--
Duane Hookom
MS Access MVP
.