Novice question

  • Thread starter Thread starter Ig
  • Start date Start date
I

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
 
Ig said:
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
Click to expand...

The field length. To support decimals it must be Single or Double or change the
type to Currency.
 
Hi Rick,
Where to stick this? I have one such field that is unbound and another is
bound to SQL Server.
 
Ig said:
Hi Rick,
Where to stick this? I have one such field that is unbound and
another is bound to SQL Server.
Click to expand...

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.
 
Back
Top