Creating New Line in a TextBox
This should be really simple but I cannot figure out how to do it.
Basically I want to display an existing database field that contains some text and display it in a textbox.
The text is something like "Line 1"<br/>Line 2"
I want the <br/> to be a new line in the text box but cannot figure out how to force a Carriage return / new line
Can anyone help ?
Gus
Basically I want to display an existing database field that contains some text and display it in a textbox.
The text is something like "Line 1"<br/>Line 2"
I want the <br/> to be a new line in the text box but cannot figure out how to force a Carriage return / new line
Can anyone help ?
Gus
Comments
Try to replace "<br/>" by char(10) + char(13) at your sql and set the property "Can Grow" to true in the field and band.
The solution is so simple so thankyou for that.
For any one else who reads this just use the SQL Command which will look something like UPDATE TableX SET Field = REPLACE(@InputVariable, '
', CHAR(10) + CHAR(13))
Gus