Fix a Missing Field in the Microsoft Access Form Field List
Question details
The user needs to add a field to an Access form when it does not appear in the form's 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.
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.
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.
Open the form in Design View, then select Design > Add Existing Fields to display the Field List.
In the Field List pane, select Show all tables, then expand the table containing the missing field.
Drag the field from the table onto the form. If Access asks about a relationship, review and specify the appropriate relationship before continuing.
Save the form, switch to Form View, and verify that the new control displays the expected data.

Check the Form's Record Source and Reopen Access
Use this method if the field is still unavailable or the form does not display the expected data.
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.

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.




