Wednesday, March 7, 2012

Carriage Returns

I have a SQL table with a "Text" column in it. The report does not show
the carriage returns in the text, making it very hard to read.
I tried changing my SELECT to do a REPLACE(tblProject.ShortDesc, CHAR(10),
'<BR>') and this actually printed out the literal '<BR>' in the report.
Any ideas?
Thanks,,, CliffTry vbcrlf.

No comments:

Post a Comment