2 decimal places

[Matthew]

I have a field that is a number type, size single, format general number,
and 2 decimal places.

However, it will let me enter data with 7 decimal places.

What's up?

Matthew

 

[Ken Snell]

ACCESS won't prohibit the entry of more decimal places when you set the
decimal places to 2...that simply controls the display of the number, not
what is stored. And the display will only limit to 2 decimal places if you
use Fixed instead of General Number as the format.

If you want to limit the entry of numbers to be no more than 2 decimal
places, you may need to use an input mask or some type of validation rule.

 

[fredg]

I have a field that is a number type, size single, format general number,
and 2 decimal places.

However, it will let me enter data with 7 decimal places.

What's up?

Matthew

Mathew,
Set the Format to Fixed, not General.
Be aware that this only effects how the data is displayed, not how it is
stored. If you have entered a number with more than the 2 decimals, that
is the number Access will use in calculations, not the 2 decimal one
displayed.