Office Settings & Configuration

How to Unhide a Permanently Hidden Field in Microsoft Access

John WilsonJohn Wilson Oct 23, 2026 871 views

Question details

The user needs to restore a field in Microsoft Access that was hidden and is no longer visible on the form or table.

How to Unhide a Permanently Hidden Field in Microsoft Access
Product
Microsoft Access
Device & OS
not provided
Scenario
Attempting to restore visibility to a database field for viewing or printing purposes.
Observed behavior
The field is missing from the table or form layout, and standard recovery methods may not work depending on whether the field was hidden in datasheet view, had its visible property changed, or was completely removed.
Before you start

Determine exactly how the field was hidden—whether in Datasheet view, Design view, or if the control was entirely deleted—as this dictates the correct recovery method.

Solution 1Recommended

Unhide Fields in Datasheet View

Use this method if the column was hidden while viewing the table in Datasheet view.

When you right-click a column and select 'Hide Fields' in Datasheet view, the data remains in your table but is visually hidden. You can quickly restore it using the column header context menu.

1
Open Datasheet View

Double-click your table in the Navigation Pane to open it in Datasheet View.

2
Access the Unhide Menu

Right-click any visible column header and select 'Unhide Fields' from the drop-down menu.

3
Select the Hidden Field

In the Unhide Columns dialog box, check the box next to the name of the field you want to restore, then click Close.

Unhide Fields in Datasheet View
Quick Tip: You can select multiple checkboxes in the Unhide Columns dialog to restore several hidden fields at once.
Free Microsoft Office alternative

Looking for a Free Alternative for Your Daily Office Tasks?

While WPS Office does not include a database management tool like Access, it is an exceptional, free alternative for handling your Word documents, Excel spreadsheets, and PowerPoint presentations. Enjoy a lightweight suite with high compatibility and a familiar interface.

  1. 1. Download the Installer: Visit the official WPS Office website and download the free installation package.
  2. 2. Install the Software: Run the installer and follow the simple on-screen instructions to set up WPS Office on your device.
  3. 3. Open Your Documents: Launch WPS Office and instantly open, edit, or create compatible documents, spreadsheets, and presentations.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Lightweight architecture ensuring fast installation and smooth performanceFamiliar user interface for a seamless and intuitive migrationBuilt-in PDF editor and converter for extensive document management
QA img-9

Frequently Asked Questions

Why can't I see the 'Unhide Fields' option when I right-click?

The 'Unhide Fields' option is specifically found in Datasheet view. If you are in Design view, Form view, or Layout view, this option will not appear. You will need to switch to Datasheet view to use this feature.

What is the difference between hiding a field and deleting a control?

Hiding a field merely removes it from the current visual layout without altering the underlying data or structure. Deleting a control from a form removes it entirely from that form's design, meaning you must re-add it from the 'Add Existing Fields' pane to see it again.

How do I print a table without hidden fields showing up?

The best practice for printing in Access is to avoid printing tables or forms directly. Instead, use the Access Report Wizard to create a dedicated report that includes only the specific fields you wish to print, ensuring a professional and tailored layout.