Help with high precision currency field, unbound

[ironfelix717]

Hi,



I am having annoying struggles with writing a 6 place decimal precision currency to my table. I cant get the field properties right for some reason.

The details are...

Unbound textbox with the properties of
Format: currency
decimal places: 6

With the field properties being
Type: currency
decimal places: 6
Format: BLANK

I've tried a number of things but usually the number is rounding...

What properties for the field should be set so that a currency field always takes on a 6 place decimal.

Example:

User types ".06" into textbox, which auto formats to $.060000

The table is written to and that corresponding field gets exactly that textbox currency value.

Thanks for the help,

Regards

[ArviLaanemets]

From Currency data type definition:
Currency variables are stored as 64-bit (8-byte) numbers in an integer format, scaled by 10,000 to give a fixed-point number with 15 digits to the left of the decimal point and 4 digits to the right.

Use Numeric (Standard) instead!

[ironfelix717]

Hi, thank you, numbers i will do!

Thanks