Preventing rounding numbers to nearest dollar

[Guest]

When entering currency data into a form Access rounds the number up or down
to the nearest dollar. The fields for the form and table are formatted for
currency, 2 decimal places, field size is long integer. I am not using any
queries. How do I prevent rounding numbers to nearest dollar?

MS Access 2003

Thanks.

 

['69 Camaro]

Hi, Ron.

When entering currency data into a form Access rounds the number up or
down
to the nearest dollar. The fields for the form and table are formatted for
currency, 2 decimal places, field size is long integer.

Since Long data types are "whole numbers" and don't allow for decimals,
change the Long data type in the table to the Currency data type.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Joseph Meehan]

When entering currency data into a form Access rounds the number up
or down to the nearest dollar. The fields for the form and table are
formatted for currency, 2 decimal places, field size is long integer.
I am not using any queries. How do I prevent rounding numbers to
nearest dollar?

MS Access 2003

Thanks.

Integers are ... well they are integers which mean whole numbers.

From the help file.

If the DataType property is set to Number, the FieldSize property settings
and their values are related in the following way.

Setting Description Decimal precision Storage size
Byte Stores numbers from 0 to 255 (no fractions). None 1 byte
Decimal Stores numbers from -10^38-1 through 10^38-1 (.adp)
Stores numbers from -10^28-1 through 10^28-1 (.mdb) 28 12bytes
Integer Stores numbers from -32,768 to 32,767 (no fractions). None 2
bytes
Long Integer (Default) Stores numbers from -2,147,483,648 to
2,147,483,647 (no fractions). None 4 bytes
Single Stores numbers from
-3.402823E38 to -1.401298E-45
for negative values and from
1.401298E-45 to 3.402823E38 for positive values. 7 4 bytes
Double Stores numbers from
-1.79769313486231E308 to
-4.94065645841247E-324
for negative values and from
4.94065645841247E-324 to
1.79769313486231E308 for positive values.