VBA for Proper Case

[fjcunninghamjr]

Good Morning,
I am trying to create an AfterUpdate event that will change my field "CITY" to proper case.
I've tried #StrConv([CITY],3)#
The more I try to fix it, the more confused I get. Can someone help?
Frank

[isladogs]

The # shouldn't be part of the code!
This will convert a string to proper case

?StrConv("HElLo woRlD",3)
Hello World

This query will display a text field T in proper case

SELECT id, T, StrConv([T],3) AS Expr1
FROM Table1;

The original data isn't converted with the above. To do so, use an update query

UPDATE Table1 SET T = StrConv([T],3);