September 14, 2006 at 2:26 pm
I have a concanteated field in SQL (in order to get a new line):
'some text' + CHAR(10) +CHAR(13) + 'more text'
which I pass through to MS Access. It displays as:
some text | | more text
how do I get my new line? Is there a compatibility issue between SQL and Access?
Sam
September 14, 2006 at 2:37 pm
Try putting a return in the field manually, maybe it's the control that is not set to show line feeds.
September 15, 2006 at 2:15 am
You want the CHARs in the other order.
Put 'text' + CHAR(13) + CHAR(10)+ ' text'
September 20, 2006 at 8:19 am
If you just want a new line through VBA code use vbCrLf like this
"text" & vbCrLf & "more text"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply