I have a address field that is all caps. How do I make the
address just first letter caps,
or have N, W, S,E caps,
or have Ln, Dr, Ct Rd (Anything that is ln ,dr, ct, rd should be Ln, Dr, Ct, Rd)
so if my address's are
123 abc ln the formatted address should be 123 Abc Ln
456 w pseo dr formatted address should be 456 W Pseo Dr
address just first letter caps,
or have N, W, S,E caps,
or have Ln, Dr, Ct Rd (Anything that is ln ,dr, ct, rd should be Ln, Dr, Ct, Rd)
so if my address's are
123 abc ln the formatted address should be 123 Abc Ln
456 w pseo dr formatted address should be 456 W Pseo Dr