My access database has opened in design view not a user view

Accounts 0 Reputation points
2026-09-17T11:23:44.0666667+00:00

My access database has opened in design view not a user view How do I get the user view back

Microsoft 365 and Office | Access | For business | Windows
0 comments

2 answers

Sort by: Newest
Most helpful Newest Oldest
  1. George Hepworth 23,120 Reputation points Volunteer Moderator
    2026-09-17T12:16:46.52+00:00

    "...access database has opened in design view..."

    That description doesn't make sense for the Access database itself. It would make sense for a single form or a single report to be in either design view or normal view, though. Perhaps what you mean is that the Navigation Pane appears and the start up form doesn't open, or something like that?

    So, to help us understand your problem, please provide screen shots of what you actually see when the database opens.

    Was this answer helpful?

    0 comments
  2. Kristen Tran 1,700 Reputation points Independent Advisor
    2026-09-17T11:35:43.16+00:00

    Hi,

    Based on your description, it sounds like the database is currently opening in Design View instead of the normal user-facing form. To switch back to the user view, please try the following:

    1. If the form is currently open in Design View, press F5 to switch to Form View.
    2. Alternatively, right-click the form in the Navigation Pane and select Form View. Access uses Form View to display and work with records, while Design View is intended for modifying the form's structure.

    If the database starts in Design View every time you open it, you may need to restore the startup form:

    1. Open the database and go to File > Options.
    2. Select Current Database.
    3. Under Application Options, locate Display Form and choose the form that users should see when the database opens.
    4. Select OK, then close and reopen the database for the change to take effect.

    As an additional check, if you opened the database while holding the Shift key, Access may have bypassed its normal startup settings. In that case, close the database and reopen it normally without holding Shift.

    For reference:

    I hope this helps restore the database to its normal user view. If the issue persists, please let me know whether all forms are opening in Design View or only a specific form, and I’ll be happy to assist further.

    Kind regards.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.