Digit to right of decimal stays at0

[Guest]

In forms view, I enter a number as 32.2, then I hit enter, and the 2 to the
right of the decimal returns to 0. I have my format as fixed and decimal
places as 1. what am I doing wrong?

 

[Jeff Boyce]

Rich

"format" is a display characteristic. If the underlying data type of the
field happens to be Integer, you will ALWAYS have a .0 for a formatted
display, since it is only the integer portion that is being stored.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[fredg]

In forms view, I enter a number as 32.2, then I hit enter, and the 2 to the
right of the decimal returns to 0. I have my format as fixed and decimal
places as 1. what am I doing wrong?

Most likely the field the control is bound to is a Number datatype
with a Field Size of Integer.
By definition, an Integer cannot contain a decimal portion.
Either change the Field Size to Double or Single or change the
datatype to Currency.

 

[John Vinson]

In forms view, I enter a number as 32.2, then I hit enter, and the 2 to the
right of the decimal returns to 0. I have my format as fixed and decimal
places as 1. what am I doing wrong?

Most likely using the default Long Integer datatype. Open the table in
design view; select this field; and look at the first row of the field
properties in the lower left.

Change this to Float or Double to allow decimals.

John W. Vinson[MVP]