How to get carriage return to display

[M8KWR1]

I am accessing an sql table with a text field.

I am adding a label control at runtime, with the data from the above field.

When i am creating the data it contains carriage returns, but when it is displayed on the webpage, it is just one line of text.

What are my options to get this work. I know i could have many labels with all different aspects of the text i am trying to display, but this would also create additional columns in the sql table.

Many thanks

 

[RiverGuy]

Try something like

MyLabel.Text = MyLabel.Text.Replace(ControlChars.CrLf, "<br>")

 

[M8KWR1]

brilliant, that works.

is there another way so a user would not have to put the <br> into the text??

 

[HarleyQuinn]

You've lost me, where in RiverGuy's answer does the user have to input the <br>?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[RiverGuy]

The user enters the CrLf, but when you display the string in the text box, you use the Replace function for the display.

 

[M8KWR1]

sorry, my fault i was reading it up-side down and back-to-front...

Many thanks again, perfect... i should of tested it before i commented....