If you mean you want the data you type in a text field to be automatically formatted like 'Each Word Starts With A Capital', so you don't have to type them yourself, the solution is in http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20453575.html
Put the appropiate VBA-coding (seems like one line suffices, because it's a standard function)in the AfterChange event procedure for such a field.
Hope this helps.
I am creating this new data base and I find if could just insert some Value so that the First Letter of each word would be a Capital my input would be a lot faster.
I have no problem with all Upper case I am using that for some of the columns.
using Office 2003 Porfessional.