Skip to main content

Access Junkie - MVP Alumnus

Home
Access Inside Out Books
Access 2010 FAQ
Access 2007 Training
Access 2007 FAQ
Access 2007 KB Articles
Technical Articles
Links
MSDN Articles
Blogs
Forums
Contact Us
About Us
Member Login
Access 2010 FAQ

 

I've heard there is a Search box for the Navigation Pane. Where do I find it?

 

By default, the Search Bar feature is turned on when you create new databases in Access 2010. However, if you're opening an existing database (like an MDB for exaample), you must turn it on through the Navigation Pane. You can enable this feature in one of two ways. For the first method, right-click the top of the Navigation Pane and then click Search Bar, as shown in the following screenshot.

 

 

Now you can see the Search Bar at the top of the Navigation Pane. Access searches for objects (filters would be a more precise term) that match what you type in the search box, regardless of object type.

 

 

In the following example, as I type the word "list," Access filters the list of object names to those that contain the sequence of characters I entered anywhere in the name. With each successive letter I type, Access reduces the list of objects shown in the Navigation Pane because there are fewer objects that match the search criteria. Here's a quick "Inside Out" tip for you: To maximze your search across all the objects, make sure you have set the Navigation Pane menu category to one of the built-in categories such as Object Type or Tables and Related Views.

 

 

To clear your search criteria, you can either delete the existing text using the Backspace key or click the Clear Search String button on the right side of the Search Bar, as shown in the following screenshot.

 

 

The second way to open the Search Bar is to right-click the top of the Navigation Pane and then click Navigation Options from the shortcut menu, as shown below.

 

 

When Access opens the Navigation Options dialog box, select the Show Search Bar check in the bottom left corner, and then click OK, as seen in the following screenshot.

 

 

 

See more tips and tricks like this in my book: Microsoft Access 2010 Inside Out

 

 

 

Back to FAQ main page