Decimal places in forms

[Kazlou]

I have a number field in a table, and I want to display 4 decimal places
regardless of how many are entered.
I've gone into the table, set the field size to interger, formal to general
number and decimal places to 4
Then on the form I've gone into the properties and set the field to general
number and the decimal places to 4.
When I put a number in it rounds it off to no decimal places.
Help please - what am I missing>>
thanks
karen

 

[Steve Sanford]

I've gone into the table, set the field size to interger, formal to general
number and decimal places to 4

Integers are *whole* numbers. They *do not and can not* have decimal parts
of a number. It doesn't matter how many places you set the decimal property
to.

To have/show decimals, change the field size to Single, Double or Decimal
type.


HTH

 

[Keith Wilby]

I have a number field in a table, and I want to display 4 decimal places
regardless of how many are entered.
I've gone into the table, set the field size to interger, formal to
general
number and decimal places to 4
Then on the form I've gone into the properties and set the field to
general
number and the decimal places to 4.
When I put a number in it rounds it off to no decimal places.
Help please - what am I missing>>
thanks
karen

To add to Steve's comments, tables are merely buckets for your data, you
wouldn't normally concern yourself with formatting at table level, do that
in the form.

Keith.
www.keithwilby.co.uk