Dear All

I'm facing problem while running form. the form has linked with a table.
This table has a field named 'amount'. the data type of this field is double.I need to put values upto 99 Lacs with two digit decimal places. But as I entered the amount greater than 40,000/ there was a message pop up having message
Run time error '6': Overflow

What should I do for the solution?

I think I' making mistake in field data type.

The requirement is that the amount should be upto 99 lacs i.e. 9900000.00 with two digit decimal places.