trm1945

Automatically leaving a field with 6 characters or 7 including a space.

Discussion created by trm1945 on Apr 6, 2014
Latest reply on Apr 6, 2014 by disabled_winfried

Canadian Postal Codes can be written two ways: eg. V9L3X9 or V9L 3X9. In a program, it's easy to code in a "Goto Field" command after the last character for the case of 6 xor 7 characters. I'm having a problem of leaving the field after both cases. A simple example is:

If (Length ( field ) = 6

Go to Field

And, the same for length of 7 characters but in the case where the Postal code can be keyed in either way, I get stuck. Char (32) and Char (20) and " " were tried as space identifiers but no luck. A script trigger is set to "On Object Modify" for this Field and If I write the script to leave the field after typing in the 6th character, it works. Same for the 7th character but not for either case which is what I'm after.

Outcomes