Capitalizing First letter in Last Name

[Darrell]

Hope this is in the right fourm. I need to know how to make the first letter of a persons last name Capitalized along with there Middle Inital, and there first name. I have 3 sperate fields for the name "last name", "MI", "first name". Aslo if the have the cap locks on I only want to first inital capitalized and the rest of there name in lower case. Hope this isn't to complicated, and I hope i haven't babbled to much.

Thanks

[-Queue-]

Proper(fieldname) will do the trick.

[kenneth2k1]

Here is some more info on the topic.

[Anatoli]

RE: Proper(fieldname) will do the trick.

You can run that in script and replace old text in field with properly formatted text or show calculated fields with the above formula.