Others

Why Microsoft Access Shows Decimal Places in a Long Integer Field

Algirdas JasaitisAlgirdas Jasaitis Nov 18, 2026 869 views

Question details

The user wants to understand and remove decimal places displayed for a Long Integer field in Microsoft Access.

Why Microsoft Access Shows Decimal Places in a Long Integer Field
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.
Before you start

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.

Solution 1Recommended

Change the Access field format to General Number

Use General Number to display a stored Long Integer without forcing decimal places.

1
Open the table in Design View

In the Navigation Pane, right-click the table containing the field and select Design View.

2
Select the field

Click the field that shows decimal places, then locate Field Properties in the lower pane.

3
Change the format

On the General tab, set the Format property to General Number instead of Fixed.

4
Save and check the display

Save the table, open it in Datasheet View, and confirm that the Long Integer values appear without decimal places.

Change the Access field format to General Number
The stored value stays the same: Changing the Format property affects how the value is displayed, not the underlying Long Integer data. A form or report control can have its own Format property.
Free Microsoft Office alternative

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.

Format whole-number data in spreadsheetsCompatible with Microsoft Excel XLS and XLSX filesFamiliar spreadsheet interface for an easy transitionFree and lightweight office tools
microsoft office alternative - wps office

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.