I've already posted a similar question and thought I cracked it so closed it out. However, I am having a few issues.
If you take the following sentence, taking not of the line spacings:
Once upon a time
In a Land, far far away
There lived a hobbit
This sentence would actually look like this in the SQL Server field, and more importantly in my multiline textbox in a Visual Studio textbox:
Once upon a time [2 little squares] In a Land, far far away [2 little squares] There lived a hobbit.
How do I remove these squares and re-format into the appropriate fashion?
I was using the attached code. I put this under the cell change of a datagridview, however, what I found was that it changed the value in the textbox everytime I moved cell, increasing the number of little squares!
Any ideas anyone?
TextBox1.Text = Replace(TextBox1.Text, Chr(10), vbNewLine)