Carriage Returns in textboxes | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Carriage Returns in textboxes

Hi, I’m new to this forum and I hope somebody can help me. Before using reporting services if I wanted a carriage return in my html textboxes, I simply added <br> to the database varchar field. The browser replaced the <br> with a carriage return in the html output.
However reporting services just prints <br> in the textbox. Is there a code I can use in reporting services that the application will replace with a carriage return ? Or maybe theres a better way of doing this ?
Many thanks in advance for any help, Steve.

maybe you can try to add chr(13)
Ive just done that very thing ….. it formats the html nicely, but still doesnt insert a linebreak in the displayed data So Im looking for a way of inserting a break Anyone ? Graham
Ive just looked at the microsoft newsgroup ->…x?dg=microsoft.public.sqlserver.reportingsvcs and found the answer there ….. insert a vbCRLF – it gets rendered as a linebreak hurrah