Last week we asked..."How do you hide and unhide system and custom objects in Access?" The answer follows:
- To hide an object, right-click it in the Database window or Access 2007's Navigation Pane, choose Properties from the resulting submenu, and check the Hidden option in the Attributes section on the General tab.
- To unhide hidden objects, choose Options from the Tools menu and check the Hidden Objects option in the Show section on the View tab. In Access 2007, right-click the Navigation pane's menu bar, select Navigation Options, select Show Hidden Objects, and click OK. If hiding the object doesn't work (it's still visible in the Database window or Navigation Pane) most likely, the Hidden Objects option is currently checked. Uncheck it, and the hidden objects should disappear.
- Access hides System objects by default. To unhide them, choose Options from the Tools menu. Then, check the System Objects option in the Show section on the View tab. In Access 2007, right-click the Navigation pane's menu bar, select Navigation Options, select Show System Objects, and click OK.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.