I have created a form in Access in that form I have a field named address. In the property sheet under Event Tab, After Update section I added the VBA Code:
Me.Address = StrConv(Me.Address, vbProperCase)
However, When I add and address with a direction it looks like this:
1212 Main Street Sw
I would like it to read “1212 Main Street SW”
So I need to figured out how to Add the Upper Case function to NW , SW, NE, SE