Numeric(15,6) - The decimal field's precision is too small

I add a decimal field in ms access 2003. Its data type is Numeric(15,6).

In access, I define it like below

Data Type: 'Numeric'.

Field Size : Decimal

Precision : 15

Scale : 6

Decimal Places : 6

From Window application, I try to modify its value to

'123456.22223'

. I got this error -

The decimal field's precision is too small to accept the numeric you attempted to add.

But in ms access, using sql command, I can update th开发者_StackOverflow社区is value. Why?

My vb.net code is below

mClass.ExchRate = IIf(txtExchRate.Text = "", 0.0, CDec(txtExchRate.Text))

Here, data type of ExchRate field of mClass is also decimal. And then pass this value to sql update command.