I am looking for the format to use when I only want the first letter of a field in Uppercase. I can find all Lowercase or all Uppercase but don't know how to do first letter only. Thanks.
Printable View
I am looking for the format to use when I only want the first letter of a field in Uppercase. I can find all Lowercase or all Uppercase but don't know how to do first letter only. Thanks.
Schuh
You could use StrConv(string, conversion) where conversion is UpperCase, LowerCase or ProperCase.
Suppose you have entered text in a field called LastName then the following code would convert the first letter of the LastName to a ProperCase e.g. jones would become Jones
Private Sub LastName_AfterUpdate()
LastName = StrConv(LastName, vbProperCase)
End Sub
Have a look at the Strconv function at this location http://support.microsoft.com/kb/253911/en-us.
Thanks. I will try this.