After Update Upper/Lower case letters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scotts - 21 Oct 2005 16:41 GMT

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

-----------------
Scott

Reply to this Message

Lynn Trapp - 21 Oct 2005 16:54 GMT

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.

Signature

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

>I have my fields setup to make the first letter uppercase, however, it
>makes
[quoted text clipped - 9 lines]
> -----------------
> Scott

Reply to this Message