I use this - sInput2 = UCase(Mid(sInput2, 1, 1)) + LCase(Mid(sInput2, 2)) to force upercase on first two characters of text in customer number eg db1234 to go DB1234

Does any one know how to force input like new york to force the N and Y to uppercase. N is ease but I can't managed the one after a space. Also how to force after a .

Lots of people not inputing data corectly

Much apreciated