I have an application for our contractors time and expenses. The expenses are entered as line items in a subform. This application adjusts the total each time the date, amount, quantity, or currency type is selected or changed. When users enter commas in the decimal field for the Amount, it causes an error that stops the script from continuing so it if there was already a total calculated, and someone changes the Amount, and adds a comma, it won't calculate the total, which is fine, but if there is already a total calculated, it won't recalculate or clear the total which is a big problem.
Is this normal behavior for a decimal field to not handle commas for 1,000.00 or 1,000,000.00. If so, is there a way I can get the script to continue with or without the commas?