Office Settings & Configuration

Tips for Opening and Closing Microsoft Access Menu Forms

WPS Content Manager Sep 30, 2026 869 views

Question details

The user is looking for tips and best practices for navigating between Microsoft Access menu forms, including managing visibility and passing values.

Tips for Opening and Closing Microsoft Access Menu Forms

Product: Microsoft Access
Device & OS: not provided
Scenario: Designing database navigation controls and managing form visibility during transitions without relying solely on complex VBA.
Observed behavior: Users need efficient alternatives to simply opening one form and hiding another, such as utilizing hyperlinks, form events, and OpenArgs.

Before you start

Ensure you have your Access database opened in Design View and have a backup copy saved before modifying form properties or event triggers.

Solution 1Recommended

Use Labels with HyperlinkSubAddress for Navigation

Format a label to act like a button and use its hyperlink property to seamlessly open another database object without writing extensive code.

Buttons can also be formatted to look like labels while retaining properties such as HoverForeColor and HyperlinkSubAddress. This gives you flexible design control over your menu forms.

Insert a label control

Open your menu form in Design View. Select the Label tool from the Design ribbon and draw it on your form.

Configure the hyperlink property

Select the label, open the Property Sheet, and navigate to the Format tab. Enter the name of the target form in the 'HyperlinkSubAddress' property.

Remove the underline formatting

If you do not want the link underline to be visible, go to the Font settings in the Property Sheet and set 'Font Underline' to False.

Use Labels with HyperlinkSubAddress for Navigation

Design Flexibility: Using labels for navigation keeps your form lightweight and allows for cleaner, text-based navigation menus.

Solution 2

Hide the Menu Automatically with the Deactivate Event

Use the menu form's Deactivate event to automatically hide it as soon as another form is opened.

Solution 3

Pass Data to Dialog Forms using OpenArgs

When opening a form in dialog mode, the calling code is paused. Use OpenArgs to safely pass one or multiple values to the new form.

Free Microsoft Office alternative

Looking for a Lightweight Data Management Alternative? Try WPS Office

While Microsoft Access is a powerful database tool, setting up complex forms and relational databases isn't always necessary for standard data tracking. WPS Spreadsheet provides a free, highly compatible, and user-friendly alternative to manage your records, generate reports, and analyze data without needing to program custom menu forms.

1. Download the software: Visit the official WPS Office website and download the free installer for your operating system.
2. Install WPS Office: Run the setup file and follow the straightforward on-screen prompts to complete the installation.
3. Start managing data: Launch WPS Spreadsheet to organize your data tables, apply filters, and build dashboards effortlessly.

Seamlessly compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Easily track and manage structured data using robust spreadsheet features and data validation.Lightweight installation that runs smoothly on most devices without system bloat.Familiar tabbed user interface, making the transition effortless.

microsoft office alternative - wps office

Frequently Asked Questions

Can I make a button function and look like a hyperlink label in Access?

Yes. A standard button can be formatted to look completely flat and transparent like a label. It retains button-specific properties like HoverForeColor and HyperlinkSubAddress, allowing it to seamlessly open other database objects.

How do I remove the underline from a hyperlink label?

If you are using a label as a hyperlink but do not want the traditional underline to appear, open the Property Sheet for that label, go to the Format tab, and change the 'Font Underline' property to 'No' or 'False'.

Why should I use OpenArgs instead of setting form variables directly?

When you open a form in Dialog mode (acDialog), the code in your original menu form pauses until the dialog is closed. Because of this pause, you cannot execute code to pass variables directly into the new form's fields. OpenArgs provides a built-in way to pass those values during the initialization of the form.

How do I pass multiple values using OpenArgs?

Since OpenArgs only accepts a single string, you can pass multiple values by concatenating them with a specific delimiter (such as 'ID:101|Status:Active'). Once the target form opens, you can use the VBA Split() function in the form's On Load event to break the string apart and use the individual values.

Office App Problems