Capitalize first letter instead of entire string.

[blyxx86]

I have the code to capitalize an entire string when it is input, but would like to capitalize just the first letter of a box, or match the case of a drop down list..

My current code is thus:

Private Sub Serial_AfterUpdate()
    'Makes serial field input all caps into database no matter what.
    Me.Serial = StrConv(Me.Serial, vbUpperCase)
End Sub
 

Perhaps there is a way to change "StrConv" to another piece of code that is more specific, and allows wildcards?

Another option, I have a drop down list of names, but I type in the first few letters first, and then select from there, is there a way for it to match the case of the drop down field instead?

[Killer42]

If you want to convert the first letter of each word, just use vbProperCase. Converting just the first letter would be fairly simple, by concatenating = Ucase(Left(Me.Serial, 1)) & Mid(Me.Serial, 2).

Beyond that it's getting a little more complex, and I don't have the time to address it now. Hopefully someone else will.