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 Warren.

"gavin" wrote in message
...
I will Lynn - I promise - but just in case I don't understand (this
newsgroup is called "getting stated, don't forget!) maybe you could give
me
a bit more of a clue :-)

Regards,



Gavin




"Lynn Trapp" wrote in message
...
Take a look at the StrConv() Function.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html



"gavin" wrote in message
...
I have a field which I want to have an initial capital - I know this can
be
done by an input mask but I was wondering how it would be done with
VBA?
Some code in the Before Update property?


Thanks for any help,


Gavin