How do I show decimal places in Access 2000?

[dannablum]

When entering data into a table or form, Access is only showing the whole
number, not the decimal places I'm typing in. I've tried changing several
options in field properties, and nothing seems to work. What gives? Thanks,

 

[John W. Vinson]

When entering data into a table or form, Access is only showing the whole
number, not the decimal places I'm typing in. I've tried changing several
options in field properties, and nothing seems to work. What gives? Thanks,

It is most likely that you defined this table field using the default Number
datatype - Long Integer. An Integer is by definition a whole number.

Select the field in table design view and look at the field properties window
in the lower left of the screen. Choose "Single", "Double" or "Decimal" -
check the help by pressing F1 with this choice highlighted to see the
distinctions. Or, if you can get by with exactly four decimal places, change
the datatype from Number to Currency - despite the name, it's not specifically
a money field but rather a scaled large integer.

 

[Jeanette Cunningham]

Hi dannablum,
access will do this for example if you type 2.0 or 2.00, you will see 2 for
the number.
You can set the format function to make the number show how you want.
In the lower tab, for format you can choose Fixed, then for Decimal places
put in the number of decimal places you want to be displayed.

It is unusual to enter data directly into tables, forms are much better for
data entry. The same thing goes, you can set the Format to Fixed and the
Decimal places to the number you want.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia