Replacing VbCrLf with space

J-F

Registered User.
Local time
Today, 08:21
Joined
Nov 14, 2001
Messages
41
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???
 
Done it. After a lot of messing around, I managed to do what I wanted. Appologies for the post.
 

Users who are viewing this thread

Back
Top Bottom