Number Fields

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

When I enter a decimal in my field it rounds to the
nearest whole number, yet I set 2 as the number of
decimal places for the field.
 
Chances are that your field format is set to a Long Integer or Integer
format. Change it to Single or Double if you want decimal fractions.
 
Tony

In addition to Ken's suggestion, you may wish to consider using the
"Currency" type. This data type uses a maximum of 4 decimal places and is
guaranteed accurate to all four. The single and double data types are
subject to errors introduced by their binary storage.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top