help with Foematting uppercase

[MartinLiss]

Thanks. Trouble is that the input can be any city and is stored in access database.

So input is random and need to force the input to display capital letter after the space.

All you need to do is to substitute the variable name that contains your state name in Rhino's code, like

Debug.Print StrConv(MyStateName, vbProperCase)