"Ed Warren" wrote in message
...
Public Function Pcase(strPassed As String) As String

'Convert into proper case string

Pcase = StrConv(strPassed, vbProperCase)


End Function

Copy the above function in the code of the form or into a VBA module.
Call
it using a string : e.g. :: "the quick brown fox"

it will return :: "The Quick Brown Fox"


Ed,
I am obviously doing something wrong because this isn't working for me.
Where in the "code of he form" do I paste this?



Regards,



Gavin