Upper Case for first letter

[Sharad]

When data is entered in a text box and Add Record button updates Table how do I make the first letter to show in Upper Case ? Thanks

 

[ColinEssex]

Check out Access help.........InputMask

Col

 

[stevievee]

...or in code

left(text,1) = uCase(left(text,1))

 

[Mile-O]

That code won't work as you require an object or a variable to assign a value.

Text0 = UCase(Left(Text0,1)) & LCase(Right(Text0,Len(Text0)-1))

That will work, as will

Text0 = StrConv(Text0, vbProperCase)

 

[Sharad]

Upper Case

Text0 = UCase(Left(Text0,1)) & LCase(Right(Text0,Len(Text0)-1))

This is it. This worked great. 2nd Code did not work, maybe I did not give enough time.Thanks guys.

 

[stevievee]

Doh! That'll teach me to post in a hurry

 

[Sharad]

Mile - O - Phile

Thanks again for your input in re: Upper Case.

The code

Text0 = StrConv(Text0, vbProperCase)

converts all the first letters of all the words in a sentence to Caps. The other code converts only the firt letter to Caps

 

[Mile-O]

Glad your happy.

Regarding the diferences in capitalisation I knew; I just forgot to say.