Others

Why the Single Field Size Option Is Missing in Microsoft Access

Camila MilosovichCamila Milosovich Nov 14, 2026 869 views

Question details

The user needs to find or choose the Single field size for a numeric field in Access.

Product
Microsoft Access
Device & OS
not provided
Scenario
The user is reviewing a table field and wants to use the Single numeric field size.
Observed behavior
The Single option is not visible when the field's data type or context is incompatible.
Before you start

Identify the source table and field you want to change. If the value appears in a query or report, check whether it is calculated rather than stored in a table field.

Solution 1Recommended

Check the field's data type in Access Design view

Use this method to find the Field Size setting for a compatible Number field.

1
Open the table design

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

2
Check the data type

Select the field and inspect its Data Type column. The Single field size is available for a Number field, not for every data type.

3
Inspect Field Size

In the lower Field Properties pane, select the General tab and open the Field Size drop-down. Choose Single if it is available and suitable for the values.

4
Save and test

Save the table design, then open the table and check representative values and any dependent queries or reports.

Check the field's data type in Access Design view
Check precision before converting: Changing a field to Number can affect existing values. Single can also lose precision when converting from Double or from large integer values, so verify the results before relying on the converted data.
Free Microsoft Office alternative

Work with numeric data in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Open compatible Excel files to move spreadsheet work over easily; WPS does not change Microsoft Access field settings.

Review numeric values and calculate percentages in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Where is the Field Size setting in Access?

Open the table in Design View, select the field, and look for Field Size on the General tab in the lower Field Properties pane. The available properties depend on the field's data type.

Why can't I select Single for a text field?

Single is a numeric field size, not a setting for a Short Text field. Check the Data Type column in table Design View before changing the field, because converting existing text values to numbers can affect the data.

Should I change a Double field to Single?

Only if Single provides enough precision for your data. Double generally holds more precision, so converting to Single can round values.

Will changing Field Size fix a percentage in my report?

Not necessarily. Open the report's source query in Design View and inspect the percentage expression and its source fields. A calculated result may depend on more than one table or conversion.