This works for me:
CityC= "" ; CityV ;
Proper (CityC )
I tried your case stmt in the VALIDATION section and still get the error:
"CityC is defined to contain only specific values. You must enter a valid value."
I put a 'custom' error message in the VALIDATION section and it shows up instead of the above message which tells me the problem is with the Validation calculation.
this is the same message I get if I use VALIDATION CityC=Proper(CityC).
It occurs to me that VALIDATION may be trying to get a retuned boolean value and that this is not the place for CityC=Proper(CityC). Perhaps I need to write a script and attach it to a ScriptTrigger? (I am using v10 Advanced)
Got any more ideas?
I got it to work I created a script:
then called the script from an 'on exit' script trigger. Ba boom.