How to Fix Microsoft Access Form Values Reverting to Defaults
Question details
Users need to ensure that data entered into Access form controls is saved correctly and does not revert to blank or default values upon closing and reopening the form.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Entering routing information or data into text boxes and combo boxes within an Access form.
- Observed behavior
- After successfully entering data, closing, and reopening the form, the entered values disappear or return to defaults. Additionally, some controls display an 'Invalid Control Property: Control Source' error.
Before modifying form properties, verify that you have Design View permissions for the database and create a backup copy of your Access file to prevent accidental data loss.
Bind Unbound Controls to Valid Table Fields
The most common reason form values disappear is that the text box or combo box is 'unbound.' You must map the control to a specific field in the database table so the data has a designated place to save.
Access forms do not automatically save data unless the input controls are bound to the underlying Record Source. If a control is unbound, it only holds the value temporarily while the form is open.
Right-click your form in the navigation pane and select 'Design View'.
Click on the text box or combo box that is failing to save its value.
Press F4 on your keyboard or click 'Property Sheet' in the Form Design ribbon.
Navigate to the 'Data' tab in the Property Sheet. Click the dropdown arrow next to 'Control Source' and select the appropriate table field where you want the data to be saved.

Disable the Form's Data Entry Property
If your form appears completely blank upon opening and hides all previously entered data, the form's Data Entry property might be incorrectly configured.
Looking for a Lightweight Alternative for Data Entry?
While Microsoft Access is a powerful database tool, complex form binding issues can slow down daily operations. For everyday document routing, form creation, and data tracking, WPS Spreadsheet and WPS PDF provide a highly compatible, easy-to-use alternative.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device in minutes.
- 2. Open Existing Data Files: WPS is fully compatible with Microsoft formats, allowing you to seamlessly open and manage your Excel spreadsheets and Word documents.
- 3. Utilize Spreadsheet Forms: For straightforward data tracking, use WPS Spreadsheet built-in data forms as a lightweight, error-free alternative to complex Access databases.

Frequently Asked Questions
What does 'Invalid Control Property: Control Source' mean in Access?
This error occurs when a text box or combo box is instructed to save data to a table field that does not exist, was renamed, or was deleted from the form's underlying Record Source. To fix it, update the Control Source property in the Property Sheet to match a valid field name.
How do I know if a control on my Access form is unbound?
In Design View, unbound controls typically display the word 'Unbound' directly inside the text box or combo box. You can also verify this by checking the Property Sheet under the Data tab; if the 'Control Source' row is completely empty, the control is unbound.
Why does my Access form only show a blank record when opened?
If the form's Data Entry property is set to 'Yes', the form restricts you to adding only new records and intentionally hides all previously entered data. Change this property to 'No' under the form's Data tab in the Property Sheet to view, navigate, and edit existing records.




