Preventing rounding numbers to nearest dollar

[RonInAlbuquerque]

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.