In the database, make sure the price column is set to use the float data type.
In the Data Assist wizard, set the validation for the price column to use currency, and select the US format:
1,000,000.00
dont set the min or max character/number settings to anything, leave them as is.
if you continue to have a problem, send a copy of the page and a link where i can see the problem happen.