Why Microsoft Access Shows Decimal Places in a Long Integer Field
Question details
The user wants to understand and remove decimal places displayed for a Long Integer field in Microsoft Access.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A table field stores whole-number values as Long Integer but displays them with decimal places.
- Observed behavior
- The Fixed display format can add decimal digits to a whole-number value without changing the stored integer.
Identify the table and field displaying decimal places, and check that the field's Field Size is set to Long Integer. If the decimals appear only in a form or report, check the control's Format property as well.
Change the Access field format to General Number
Use General Number to display a stored Long Integer without forcing decimal places.
In the Navigation Pane, right-click the table containing the field and select Design View.
Click the field that shows decimal places, then locate Field Properties in the lower pane.
On the General tab, set the Format property to General Number instead of Fixed.
Save the table, open it in Datasheet View, and confirm that the Long Integer values appear without decimal places.

Work with whole-number data in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheet data. Open an exported Excel workbook in WPS Spreadsheets to view and format whole numbers. It does not change Access field properties or replace an Access database.

Frequently Asked Questions
Why does a Long Integer show two decimal places in Access?
The field or its form control may use the Fixed format, which displays a set number of decimal places. The stored Long Integer remains a whole number.
Does changing to General Number alter my data?
No. Changing the Format property in the field's Design View changes the display, not the stored Long Integer value.
Why does my form still show decimal places after I change the table field?
The form control may have its own format. Open the form in Design View, select the control, and check Format on its Property Sheet.
Can Fixed format display an integer without decimal places?
Yes. You can keep the Fixed format and set the Decimal Places property to 0 in the field or control properties. This changes the display, not the stored value.




