Hello all, i thought this would be the easiest thing to do ever, i was wrong, all i want to do is replace new lines in a textbox with " " don't tell me to turn multi-line off please, i already tried that. Well, if you can supply some word wrapping code so it doesn't scroll out of view then go ahead.

Anyways, i have the following code called in a Command Button -
VB Code:
  1. Replace Text1.Text, vbCrLf, " ", 1, -1, vbTextCompare
Which obviously doesn't work, any help ?

Thanks.