[Solved] Of decimal or numeric field in form to Currency

[gkick]

Observing a strange behaviour in my assets db

Was trying to enter a purchase value of 1.200.000 and it changed back to 1.000.000
The forms control property indeed show min max value of 1.000.000
The numeric or decimal data type(s) work fine in forms, however if converted to currency there is a problem. Anyone aware of this behaviour (bug?) I mean one wouldn t often have a million dollar item in an asset db, but hey in most of South America you are a millionaire with the equivalent of 2000 AUD

[Villeroy]

What is the column type in the underlying table?

[gkick]

Hi Villeroy,

original datatype decimal.

[F3K Total]

Seems to be a problem with a Currency-field as column within a table control.
Use a formatted field.

The forms control property indeed show min max value of 1.000.000

[Villeroy]

DECIMAL with a length of 8 and 2 decimals means that you can't store numbers bigger than 999,999.99
Make field types as big as necessary and as small as possible.
Adjust the min/max values of your form controls according to the underlying field types.

[gkick]

Thanks all ! So its the systems default length of the datatype unless specified otherwise.