Hi Leon,
I think I am too late on this(was travelling lastweek). Though by now you would have solved that yourself, still let me post on how to solve that.
Yes, when given hard spaces using keyboard, HTML ignores multiple spaces and shows off just a single space. We can force it to consider all those spaces by replacing " " with " "
Code:
Replace(strTextAreaValue," "," ")
Hope that helps.
Cheers!
_________________________
- Vijay G
Strive for Perfection