Field format - Access 2003

  • Thread starter Thread starter FrankSpokane
  • Start date Start date
F

FrankSpokane

I have never used fields before to express square feet or acres, although I
have used Access for many years.

I tried making the fields general number with 2 decimal places, and I can
type the decimals in, but then it seems to round up/down whatever I type and
show the value as a whole number.
What would be the best field type/format to express square feet of an
office, and acres of land?

Thanks for all replies
 
I have never used fields before to express square feet or acres, although I
have used Access for many years.

I tried making the fields general number with 2 decimal places, and I can
type the decimals in, but then it seems to round up/down whatever I type and
show the value as a whole number.
What would be the best field type/format to express square feet of an
office, and acres of land?

Thanks for all replies
Click to expand...

Most likely you have set the field's datatype to Number, Field Size to
Integer. By definition, an integer cannot have a decimal value.

Change the Field Size to Double, or the Datatype to Currency (the
datatype, not the format).
 
Number field
Type: Double

Or
Currency field.

You probably are trying to use a number field with the type set to Long
(or perhaps Integer) and those two types of number fields only hold
integers (no decimal positions).



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Back
Top