How to Rename a Form in Access: Quick Navigation Pane Method

Renaming a form in Access seems simple until you break something. 💡 I’ve seen users accidentally sever form dependencies by skipping one critical step in the Navigation Pane.

The process itself takes under a minute once you know the workflow. Right-click the form, select Rename, and type the new name—but first, always check for references in queries, macros, or VBA code that might still point to the old name.

You’ll avoid the dreaded “#Name?” error that appears when Access can’t find a renamed object. This method preserves all form functionality while updating the name across your database.

Works for Access 2016 through 2021. The Navigation Pane makes this foolproof.

What Youll Need

Instructions

Here’s the fastest way I know to rename forms without losing references or breaking dependencies.

Launch your Access database and ensure the Navigation Pane is visible. If it’s hidden, press F11 to toggle it on. I always start by expanding the Forms section—it’s usually near the top of the pane under All Access Objects.

Scroll or search for the form you want to rename. Right-click it once to select it. Don’t double-click—this opens the form in Design View, which isn’t what we want here. The form should be highlighted in blue when selected correctly.

With the form selected, press F2 on your keyboard. This is the universal Windows shortcut for renaming, and it works perfectly in Access. The form name will become editable, highlighted and ready for your new name.

Type the new name directly. Access will warn you if the name is invalid (like using spaces or special characters). Stick to alphanumeric names with underscores if needed. Press Enter to confirm the change.

Here’s the thing—Access forms often have references in macros, VBA code, or other objects. After renaming, open any module that might reference this form (press Alt+F11 to open the VBA editor). Use Ctrl+F to search for the old form name.

Update all references to match the new name. If you miss one, you’ll get a #Name? error when the form loads. This step is crucial for maintaining functionality.

Open the renamed form in Form View by double-clicking it in the Navigation Pane. Verify that all controls, buttons, and data sources work as expected. Pay special attention to any buttons that open other forms or run macros—they’re most likely to break after a rename.

If you encounter errors, check the Immediate Window in the VBA editor (press Ctrl+G) for specific error messages. This will tell you exactly where the old form name is still being referenced.

Tips and Common Mistakes

These quick insights will save you hours of debugging and frustration.

The Navigation Pane Hack: In Step 1, if you don’t see the Navigation Pane, don’t waste time clicking through menus—just hit F11 to toggle it instantly. I’ve watched beginners struggle with ribbon options when the keyboard shortcut is right there. Also, use the search box at the top of the pane to find your form faster if you have many.

Renaming Without Errors: In Step 2, after pressing F2 to rename, double-check for typos before hitting Enter. Access will flag invalid characters, but it won’t catch if you accidentally type a name that already exists in your database, which can cause silent failures later.

Dependency Check: Step 3 is where most people mess up. Don’t just search modules—also check reports, queries, and macros for references. A quick Ctrl+F in the VBA editor (Alt+F11) is your best friend here. If you skip this, you’ll inevitably see that dreaded #Name? error during testing.

Testing Pro Tip: In Step 4, don’t just open the form in Form View—test every single button, combo box, and linked subform. The most common breakages happen in command buttons that are hardcoded to the old form name. Trust me, catching these now saves you a headache later.

Frequently Asked Questions

Renaming a form in Access is a simple process that can be done directly from the Navigation Pane. Just right-click, select Rename, and enter your new name—it’s that easy! 🌟 Now that you’ve mastered this, try exploring other customization options like adjusting form properties or adding controls to enhance your database further.