After Update Upper/Lower case letters

[Guest]

I have my fields setup to make the first letter uppercase, however, it makes
all other letters lowercase (see code below). Is there a way I can code it
to not change the case after the first letter...as in TX (abbreviation for
Texas), which now would appear as Tx?

Private Sub CITY_AfterUpdate()
CITY = StrConv([CITY], 3)
End Sub

 

[Lynn Trapp]

Are you saying that you have the City and State stored in one field?

dallas, TX converts it to Dallas, Tx

Proper Case (constant 3 in your example) will always make the first letter
upper case and all others lower case.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html