Capitalization help

[tshirttom]

I need a column to have a default of capital letters for the first letter. I am dictating orally and when I am dictating last names I often have a problem with the name not being capitalized. I would apprecate any formatting help that would allow me to be sure the name is spelled with a capital.
Thanks in advance.

[RuralGuy]

Look into the StrConv() function in help.

[tshirttom]

Sorry not a programmer. Is their a way of using a Format or mask in design view?

[RuralGuy]

Not that I know of.

[rpeare]

there's no real need to set it up on your table, you can set up words to first letter capitalize in any queries, forms, reports you generate using that field using something like

PersonConverted: StrConv([firstname],3)

3 indicates proper case (capitalizes the first letter of each word)

Assuming it's a name field with one name it should do what you want.

if you wanted to make sure the data itself had the format you wanted you'd have to run this same thing, likey in the before update or after update event.

[tshirttom]

I don't really understand how to do this because I don't write queries, forms or reports.

[rpeare]

If you don't do anything with your data why are you using a database to store it? The whole point of a relational database is to be able to manipulate the data you put in and be able to report on specific things.

If you're not doing data entry through a form I don't know if there's a way to do what you require as you're doing data entry, you could likely perform a conversion after you're done with data entry to change your last name fields to proper case but that's really the only thing I can think of but that would require a query and from what you're saying you're only using a table which I just can't quite grip.