Capital letters in access help

[JimboS]

Don't kno wif anyone can help.

I have an access database which uses a foirm to input data. WHat I would like to do is set the formating so that when you press tab to go to the next field in ensure that all first lketters of words are in Capitals.

James

[scroots]

you use an input mask, in the table design, after selecting a field.

you use the greater than sign (>) or something.

scroots

[craigt56]

Put the following input mask in the form fields (in design view) that you want to start with capital letters:

>L<?????????????????????????

Greater than (>) means capital
Less than (<) means small
L is for letter A through Z entry required
? is for letter A through Z entry optional

Put about 15 so ?'s in to cover the possible word lengths.