automaticly capitalizing first letter in a field?

[Adam123]

How do I automaticly capitalize the first letter and only the first letter of a field automaticly?

[-Queue-]

Create an auto-enter calculation of Upper(Left( thisfield, 1 )) & Lower(Right( thisfield, Length(thisfield) - 1 )) and deselect the 'Do not replace existing values' checkbox.

[Adam123]

Thank you once agian Queue! is there a way now to make it cap the first letter of each word?

lets say the field is mercedes benz can it Cap the M and B automaticly?

[Ender]

Proper(text)