Fix Microsoft Access Database Main Form Not Opening Automatically
Question details
The user wants the Microsoft Access database main form to appear automatically when the database opens.

- 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.
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.
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.
Open the database in Microsoft Access, click File, then select Options.
In the Access Options dialog, click Current Database in the left pane.
Under Application Options, open the Display Form drop-down and select the database's main form.
Click OK, close the database, and reopen it to verify that the main form opens automatically.

Check the AutoExec Macro That Opens the Main Form
Use this when the database relies on an AutoExec macro to open the startup form but the macro is missing, renamed, or not running.
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. 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. Open or create documents: Launch WPS Office and use Writer, Spreadsheets, or Presentation to open existing Microsoft Office files or create new ones.
- 3. Save in Microsoft Office format: Use File > Save As and select .docx, .xlsx, or .pptx to keep full compatibility with Microsoft 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.




