Why the Single Field Size Option Is Missing in Microsoft Access
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.
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.
Check the field's data type in Access Design view
Use this method to find the Field Size setting for a compatible Number field.
In the Navigation Pane, right-click the source table and select Design View.
Select the field and inspect its Data Type column. The Single field size is available for a Number field, not for every data type.
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.
Save the table design, then open the table and check representative values and any dependent queries or reports.

Use Double when the field needs greater precision
Choose Double instead of Single when preserving more numeric precision is important.
Inspect the source of a calculated percentage
Use this approach when the value appears in a query or report rather than in a stored table field.
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.

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.




