Office Settings & Configuration

How to Fix an Access Form Field That Will Not Reenable

Maira Mehtab Sep 27, 2026 868 views

Question details

The user needs to troubleshoot a Microsoft Access form control that remains disabled after a status change triggered by a combo box selection.

Product: Microsoft Access
Device & OS: not provided
Scenario: Changing a status via a combo box to trigger form logic that reenables another specific form field.
Observed behavior: The target form field does not reenable because the combo box actually stores a numeric identifier, while the background code is likely checking for the displayed status text.

Before you start

Ensure you have access to the Design View of your Access form and are familiar with opening the VBA code module to review the control properties.

Solution 1Recommended

Update Form Code to Check the Numeric Bound Column

Modify your VBA logic to evaluate the numeric ID stored by the combo box instead of checking for the displayed text.

In Microsoft Access, combo boxes often pull data from a related table where the first column is a numeric ID (like an AutoNumber) and the second column is the text description. If the Bound Column is set to the ID, your code must test for the number, not the text string.

Open Form in Design View

Right-click your form in the navigation pane and select Design View.

Review Bound Column Setting

Select the combo box, press F4 to open the Property Sheet, navigate to the Data tab, and note the value in the Bound Column property (usually 1, representing the ID).

Modify the VBA Code

Open the form's VBA code module and update your conditional statements to check the numeric identifier. For example, change 'If FirstNameEntryStatus = "Active" Then' to 'If FirstNameEntryStatus = 3 Then'.

Best Practice: Using a stable AutoNumber ID is highly recommended because the stored value remains reliable even if you later change the displayed status text.

Solution 2

Verify Combo Box Row Source Properties

Ensure the combo box is correctly configured to pull both the status ID and the text description from your source table.

Free Microsoft Office alternative

Looking for a Free and Lightweight Office Suite?

While Microsoft Access is used for complex relational databases, WPS Office is an excellent, free alternative for handling your everyday word processing, spreadsheet, and presentation needs with full Microsoft Office format compatibility.

1. Visit the WPS Website: Navigate to the official WPS Office website.
2. Download the Installer: Click the free download button for your specific operating system.
3. Install and Open: Run the setup file and start opening your Office documents seamlessly.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Lightweight installation with a familiar, easy-to-use tabbed interface.Built-in PDF editing, conversion, and signing tools.Free to use for everyday document creation and data analysis.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access combo box show text but return a number in VBA?

This happens because the 'Bound Column' property is set to a hidden numeric ID column (like an AutoNumber) rather than the column containing the text description. This is best practice for database stability, but it requires your VBA code to check against the numeric value.

How do I find the Bound Column property in Access?

Open your form in Design View, select the combo box, press F4 to open the Property Sheet, and look under the Data tab. The 'Bound Column' setting dictates which column's value is stored.

Should I use spaces in Access object names?

No, it is highly recommended to avoid spaces in table, column, and object names. Use clear, continuous names like 'StatusID' to prevent syntax errors and the need for excessive bracket formatting in your queries and VBA code.

Office App Problems