this.getField(event.target.name).setAction("Format", 'AFNumber_Format(2, 0, 0, 0, "$", true)');
This is working for me, an when you type "1" into the field, it makes it into "$1.00", which is what I want. However, if I type in "5,000" it reads that as "5" when everything is summed up. I can only figure it is reading the comma as a decimal point. I thought the above code indicates that it should use commas as the seperator value (hence the 0 in that attribute's place in the formula). I just can't crack this problem. Any ideas or code? Thank you in advance.
Have you tried to remove your keystroke scripts - temporarily that is - just narrow down the source of trouble?
The formatting script works fine on my desktop:
Entering "5,000" formats as "$5.00"
Actually the script was running fine. This is what I ultimately came up with to solve the problem.
AFNumber_Format(2, 0, 0, 0, "$", true)
event.value = event.value.replace(",","");
Message was edited by: jbash83 edited to remove unrelated code