Number Fields

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

 

[Ken Snell]

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.

 

[Jeff Boyce]

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>