having issues with the simplest things in access 2010

[ittom]

in access 2010 how do you create a procedure to convert a field value so that it only capitalizes the first letter and puts the other letters in lower case?:banghead:

 

[John Big Booty]

I think the discussion in this thread should provide an answer to your question.