insert a carriage return into textbox from sql data

[bopritchard]

i return the following data from my sqlserver
"This is my \r carriage return"
i set textbox.text = to this data...

i'm expecting my text box to show

This is my
carriage return

but of course it shows

This is my \r carriage return

how do i do this

 

[ca8msm]

Use the replace function. e.g.

        Dim s As String = "This is my \r carriage return"
        Textbox1.Text = s.Replace("\r", vbCrLf)

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.