Others

How to Open an Access Database Directly to a Maximized Form

Maira Mehtab Sep 22, 2026 869 views

Question details

The user wants to configure a Microsoft Access database to automatically open a specific form in a maximized state while minimizing or hiding the Navigation Pane.

Product: Microsoft Access
Device & OS: not provided
Scenario: Configuring startup options and VBA for a distributed Access database to improve the end-user experience.
Observed behavior: The database opens directly into a user-specified maximized form with the Navigation Pane hidden from the end user.

Before you start

Before modifying startup properties or adding VBA code, ensure you have exclusive access to the database and take note of the exact name of the form you wish to set as the startup form.

Solution 1Recommended

Configure Startup Options and Form Events

Set the startup form via Access options and use VBA on the form's Open event to maximize the window and hide the Navigation Pane.

By combining Access's built-in Current Database options with a few lines of VBA code, you can control exactly how the application appears when a user opens it. This ensures a clean interface focused entirely on your chosen form.

Set the Startup Form

Go to File > Options > Current Database. Under 'Display Form', click the dropdown menu and select the form you want to open automatically.

Hide the Navigation Pane

In the same 'Current Database' options window, scroll down to the Navigation section and uncheck the 'Display Navigation Pane' box, then click OK.

Open Form in Design View

Locate your startup form, right-click it, and select Design View. Open the Property Sheet and navigate to the Event tab.

Add VBA to Form Open Event

Click the ellipsis (...) next to 'On Open' and select Code Builder. Add 'DoCmd.Maximize' and 'DoCmd.RunCommand acCmdWindowHide' to the VBA module.

Shift Key Bypass: You can bypass these startup settings and regain access to the Navigation Pane by holding down the SHIFT key while opening the Access database.

Solution 2

Disable Navigation Pane Access for End Users

Use an AutoKeys macro to prevent users from using the F11 shortcut to unhide the Navigation Pane in distributed databases.

Free Microsoft Office alternative

Looking for a Free and Lightweight Office Suite?

While WPS Office does not include a database management tool like MS Access, it is an exceptional, free alternative for Microsoft Word, Excel, and PowerPoint. If you are looking to streamline your document, spreadsheet, and presentation tasks, WPS Office offers a highly compatible and familiar user interface.

1. Download WPS Office: Visit the official WPS website and click the free download button for your operating system.
2. Install the Software: Run the downloaded installer file and follow the straightforward on-screen instructions.
3. Start Creating: Open WPS Office to easily manage, edit, and collaborate on your documents, spreadsheets, and presentations.

Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx).Lightweight installation that runs smoothly on older devices.Familiar, tabbed user interface for a seamless transition.Built-in advanced PDF editing and conversion tools.

microsoft office alternative - wps office

Frequently Asked Questions

How do I bypass the startup form if I need to edit the database design?

You can easily bypass the startup options, including the startup form and hidden Navigation Pane, by holding down the SHIFT key while double-clicking the database file to open it.

Why is the Navigation Pane still visible after clearing the Display Navigation Pane option?

If the pane is still visible, ensure you have restarted the database entirely, as many Current Database startup options require a restart to take effect. Also, verify that no conflicting VBA code is forcing the pane to show.

Can I restore the Navigation Pane when the maximized form closes?

Yes, you can add VBA code to the startup form's On Close event. Using a command like DoCmd.SelectObject acForm, , True followed by an unhide command will restore the Navigation Pane when the user exits the form.

Office Quick Solutions