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