Force Capital Letters in Fields

[dvannoy]

Is there a way to either force capital letters in each field or just make the first letter of each word capital..

even if the user does not type it?

thanks in advance

 

[seaport]

You may try Ucase() function, which make every letter in a string captial.

And you can try

Ucase(left(strWord,1)) & right(strWord, len(strWord)-1)

to make the first letter of a word capical.

Seaport

 

[gusbrunston]

In the property sheet for the control, enter an input mask. The "greater than" symbol forces upper case. The following mask will force all letters to be upper case:
&quot;>LL?????????????&quot; (leave out the quotes -- requires the entry of two characters, the ? marks stand for optional.) See Access Help for &quot;input masks&quot;. You can specify all upper case, first character upper case, only characters, only digits, required, optional, etc. You can also put this input mask in the table while in design view. I spend a lot of time trying to prevent upper case.... the &quot;<&quot; forces lower case...this mask forces a name to have an upper case first character, and lower cases following characters:
>L<???????????. Therefore, JOHNSON is forced to Johnson.
Gus Brunston
An old PICKer
padregus@home.com

 

[dvannoy]

The above works great...

Theres just one problem I ran into...That is I have a field that has a number (eg 12345678-1A) I want to force the last letter of that field to caps...now that number maynot always be the same size..could be fewer numbers.But there will always be a letter as the last character.

Thanks in advance