A question often asked is how to convert text from some case to Proper Case like the Excel function Proper(). Access has a function that does what Proper() does and a whole lot more like UPPERCASE and lowercase. The function is StrConv().
It's usage is like so:
For each type, the vbCaseToConvert is the following: