Novice question

[Ig]

I want numeric field with 3 decimal places on form.
I define 3 in it's property "Decimal Places" and Format - "General Number".
But nothing happens when entering data in this field. What is wrong here?
Thanks

 

[Rick Brandt]

I want numeric field with 3 decimal places on form.
I define 3 in it's property "Decimal Places" and Format - "General
Number". But nothing happens when entering data in this field. What
is wrong here? Thanks

The field length. To support decimals it must be Single or Double or change the
type to Currency.

 

[Ig]

Hi Rick,
Where to stick this? I have one such field that is unbound and another is
bound to SQL Server.

 

[Rick Brandt]

Hi Rick,
Where to stick this? I have one such field that is unbound and
another is bound to SQL Server.

Ok, that changes everything. Where most database engines define the various
number types by actually calling them different DataTypes Access lumps most of
them together as "Number" and uses the Field Length property to distinguish
say...Integer from Byte from Double. If you are using a SQL Server table you
need to look at the field definition in design view and see if it's a type that
supports fractional numbers.

Also try using "Fixed" instead of "General Number". I believe the decimal
places property is ignored if set to the latter.