convert first character to uppercase 1

[rmh3619]

i have a text box on a form called txtDescription

on the after update event i want to convert the first character in the txtDescription field to uppercase.

I dont want to use vbProperCase because that will convert all first characters of each word in the field to uppercase

thanks in advance

 

[Remou]

You could use Format:

Format("a bcd efgh I",">L<")
La bcd efgh i

But it may be better to go the long way around:
UCase(Left("a bcd efgt I",1)) & Mid("a bcd efgt I",2)
A bcd efgt I

 

[rmh3619]

thanks Remou, that helped!