Number Field Set As Currency

[accessuser1308]

I currently have a field on my form/table that is set as a number field.
Under the format option I have selected 'currency'. When I enter a dollar
amount it is rounding to the nearest whole dollar. Is there a way to make it
stop doing this, such that it displays the correct amount.

Thank you

 

[Dirk Goldgar]

In

I currently have a field on my form/table that is set as a number
field. Under the format option I have selected 'currency'. When I
enter a dollar amount it is rounding to the nearest whole dollar. Is
there a way to make it stop doing this, such that it displays the
correct amount.

Set the Field Type to Currency, not Number. The field type is different
from its Format, and you currently have it set to one of the integer
field sizes -- probably Long Integer.

 

[accessuser1308]

Al,

Thank you for the quick response. I did not realize that Long Integer could
not accept decimals.

Thanks

 

[accessuser1308]

Dirk,

Thank you for the quick response. I completely overlooked the fact that
there was a currency option for field type.

Thank you.