Decimal places in forms

  • Thread starter Thread starter Kazlou
  • Start date Start date
K

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
 
I've gone into the table, set the field size to interger, formal to general
number and decimal places to 4
Click to expand...

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

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