Office Settings & Configuration

Fix Microsoft Access Database Main Form Not Opening Automatically

Natalie TaylorNatalie Taylor Nov 13, 2026 868 views

Question details

The user wants the Microsoft Access database main form to appear automatically when the database opens.

Fix Microsoft Access Database Main Form Not Opening Automatically
Product
Microsoft Access
Device & OS
not provided
Scenario
The user opens an Access database that should display a startup or main menu form.
Observed behavior
The database opens without showing the usual startup form because the Display Form setting was cleared or an AutoExec macro no longer runs correctly.
Before you start

Open the target database and identify the exact name of the main form that should appear at startup. If an AutoExec macro is used, make sure macro security does not block it.

Solution 1Recommended

Set the Display Form in Access Current Database Options

Use this when the startup form is not selected in Access Options and the database opens without a main form.

The Display Form setting controls which form automatically opens when the current database starts. If it is cleared or set to none, Access opens without a startup form.

1
Open Access Options

Open the database in Microsoft Access, click File, then select Options.

2
Select Current Database

In the Access Options dialog, click Current Database in the left pane.

3
Choose the main form

Under Application Options, open the Display Form drop-down and select the database's main form.

4
Save and reopen

Click OK, close the database, and reopen it to verify that the main form opens automatically.

Set the Display Form in Access Current Database Options
Startup form restored: The selected form now opens automatically whenever the database is opened.
Free Microsoft Office alternative

WPS Office: A Free Microsoft Office Alternative When Access Startup Forms Cause Delays

WPS Office does not modify Microsoft Access startup forms, but it is a free, lightweight Microsoft Office alternative. It opens and saves Word, Excel, and PowerPoint files with a familiar ribbon interface, so you can keep working on everyday documents without Access database overhead.

  1. 1. Download WPS Office: Go to the official WPS Office download page and install the free Office suite for Windows, macOS, Linux, Android, or iOS.
  2. 2. Open or create documents: Launch WPS Office and use Writer, Spreadsheets, or Presentation to open existing Microsoft Office files or create new ones.
  3. 3. Save in Microsoft Office format: Use File > Save As and select .docx, .xlsx, or .pptx to keep full compatibility with Microsoft Office.
Avoid Access startup-form configuration issues for everyday Office documentsFree, lightweight, and easy-to-use Office suiteStrong compatibility with .docx, .xlsx, and .pptx Microsoft Office formatsFamiliar ribbon UI and seamless migration from Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access database not open the main form automatically?

Usually the Display Form setting in File > Options > Current Database is blank, or the AutoExec macro is not running. Re-select the main form and check the macro.

Where is the Display Form setting in Microsoft Access?

Open the database, click File > Options > Current Database, and look under Application Options for Display Form.

Can an AutoExec macro be blocked and stop the startup form from opening?

Yes. If Access macro security blocks macros or the AutoExec macro is renamed, it will not run. Check the Trust Center and ensure the macro exists with the correct OpenForm action.

Does WPS Office open or repair Microsoft Access database startup forms?

No, WPS Office is a word processor, spreadsheet, and presentation suite and does not manage Access database startup forms. It is a free alternative for .docx, .xlsx, and .pptx work.