Number Field Set As Currency

[Guest]

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

 

[Al Campagna]

accessuser1308,
In your table design... what Numeric "type" is it.
If you have it set to Byte, Integer, or Long Integer... those types will
not accept decimals
Try Numeric - Single
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."

 

[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.

 

[Guest]

Al,

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

Thanks

 

[Guest]

Dirk,

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

Thank you.

 

[Joseph Meehan]

--
Joseph Meehan

Dia 's Muire duit

Al,

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

Don't feel bad we get that question a lot. An integer is by definition
a whole number, that's what makes it an integer.