Tim Slattery wrote:
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote:
John Aspinall wrote: Hi,
Can someone please tell me how to capitalise all words in a string
that are seperated by spaces. The string is variable and not the
same every time hence I cant use the Ucase function as I wont know
the exact position of the start of each word.
Cheers....John
? Why won't UCase work?
Because OP wants the first letter of each word uppercase, the rest
lowercase.
Where do you see that in his post? Why do you leap from "capitalise all
words " to "first letter of each word uppercase"? He could just as easily
have wanted something like this:
abcd efg hijkl mn op
to become this:
abcd EFG hijkl MN op
Or something equally bizarre.
I congratulate you for going to the trouble of writing that code based on a
guess about what the OP wanted. I hope your guess was correct so your time
was not wasted
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.