field is not taking decimals.

[Fuga]

Hi.

I have a field (double type).

When entering a decimal number, like 12.5, it changes to 125.

I have set the decimal sign in windows control panel to point because I think that was necessary for VBA to work.

Now, when I enter 12.5 it turns to 125.

When I enter 12,5 (comma), it turns to 12.5 (point).

What´s going on here and how do I solve it?

Thanks

Fuga.

 

[Mile-O]

Might be your regional settings....

 

[tiggy]

In the table shouldn't it say

FieldSize: Double
Format: Fixed
DecimalPlaces: 2

I am a complete novice so I would not bet your life on it.

Tig

 

[Fuga]

Thanks for your replies.

Mile-O
The thing is I´ve never noticed this problem before. Actually, I think it´s just this one table. This is the only table I in which I enter data manually. The other tables are automatically appended (with point as decimalsign). I´ve tried repairing, but I guess I´ll try that again.

tiggy
I have decimals set to Auto.

Fuga.