How to add extra character during input
Lets say I have a form that contains a field name citycode, and the value entered could be xyz, abc, ddx, etc..any three letter combination.
What I want to do is add an extra character in front of the entered value, if the city is New York. So if the New York user enters xyz in the city code field, than tabs to to the next field, I want to automatically add 'N' in front of the entered xyz so that that the city code will display NXYZ, even though he entered xyz and is now at the next field.
How can this be done ? I konw I can check for the city during insert and then add the N in front of xyz to insert into the table, but I thought adding it during input might be better so that the new value can be displayed before inserting into the table.
