Capitalize the First letter of the Entry input

[vannakr25]

So I have a field name [Company]; each time I am inputting the company's name such as nissan, toyota, chevrolet, lexus, and so forth I want to make the first letter Capitalize "automatically" =Nissan, Ford, Chevrolet and so forth.  By the way table name is "Car".

How would I do that?  do I need to create a script?  do I need to use the "Calculation"?  

I pressed the Help in FileMaker Pro 18 - it shows to use of function ==> Proper (text).  However it doesn't work.

So far these are what I have tried so far....

1.  Proper(:car::company") - no luck - try to input a new entry still the company's name is all in lowercase format.

2.  Proper(car::company) - without the double quotes - no luck.

Please advise and provide and an example.

[bcooney]

You would use an auto enter calc in the field options, proper (self). Deselect “do not replace existing value, if any”.