I have a form with a large textbox with line feed enabled. I presume that this inserts a VbCrLf into the string.
On this particular textbox, I need to manipular the data in a way that the number, which is at the start of every line has a space both in front and behind it in order to perform a calculation.
The problem is that because there is a line feed in front of it, the calculation won't work and so, for the calculation, I need to replace the VbCrLf with a space.
I have tried using the replace function but it doesn't seem to work. I was replacing VbCrLf with " ".
What am I doing wrong???
On this particular textbox, I need to manipular the data in a way that the number, which is at the start of every line has a space both in front and behind it in order to perform a calculation.
The problem is that because there is a line feed in front of it, the calculation won't work and so, for the calculation, I need to replace the VbCrLf with a space.
I have tried using the replace function but it doesn't seem to work. I was replacing VbCrLf with " ".
What am I doing wrong???