Document Editing Problems

Fix a Missing Field in the Microsoft Access Form Field List

Aamir Naveed AkramAamir Naveed Akram Nov 14, 2026 868 views

Question details

The user needs to add a field to an Access form when it does not appear in the form's Field List.

Fix a Missing Field in the Microsoft Access Form Field List
Product
Microsoft Access
Device & OS
not provided
Scenario
A field is available while designing a report, and the user wants to add it to a form.
Observed behavior
The field does not appear in the Field List while the form is being designed.
Before you start

Identify the table or query that contains the missing field and open the form in Design View. Check that the field exists in the source table before adding it to the form.

Solution 1Recommended

Show All Tables and Add the Field to the Form

Use this method when the field exists in a table but is not shown in the form's current field list.

1
Open the Field List

Open the form in Design View, then select Design > Add Existing Fields to display the Field List.

2
Show the source tables

In the Field List pane, select Show all tables, then expand the table containing the missing field.

3
Add the field

Drag the field from the table onto the form. If Access asks about a relationship, review and specify the appropriate relationship before continuing.

4
Check the result

Save the form, switch to Form View, and verify that the new control displays the expected data.

Show All Tables and Add the Field to the Form
Fields from another table: A field from another table may require an appropriate relationship or a change to the form's record source before it displays the intended data.
Free Microsoft Office alternative

Work With Office Documents and Tables in WPS Office

WPS Office is a free, lightweight alternative for working with documents, spreadsheets, and presentations. Its familiar interface and Microsoft Office format compatibility make it easy to move everyday files between suites. It does not repair Access forms or replace Access database design.

Use spreadsheet tables to organize and review data outside AccessOpen and edit Microsoft Office formats, including DOCX, XLSX, and PPTXNavigate a familiar, easy-to-use interfaceUse a free, lightweight suite for everyday office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why is a field available in a report but not in my form?

The report and form may use different record sources. In the form's Design View, select the form, open Property Sheet > Data, and compare its Record Source with the report's.

Where can I find Show all tables in Access?

Open the form in Design View and select Design > Add Existing Fields. Look for Show all tables in the Field List pane.

What if the missing field is not in the form's query?

Open the query named in the form's Property Sheet > Data > Record Source in Query Design. Add the field from the appropriate table, check the joins, and save the query.

Will restarting Access restore the missing field?

Reopening Access may refresh the Field List, but it will not add a field that is missing from the form's record source. Check the source table or query if the field remains unavailable.