Software

Office Challenge: How do you hide and unhide Access objects?

Access hides some objects by default, but you can hide objects as well. How do you hide and unhide system and custom objects in Access?
Everyone knows there's usually more than one way to do something in any Office app. The key to efficiency is to know which method to use when. Sometimes, it doesn't matter. But more often than not, one method is more efficient than the others. Each Friday, we'll publish a weekly Office Challenge. We hope you'll share your solutions, all of them: The common, the unique, the insightful, and even the "You'll think I'm nuts, but..." methods.  We want to hear them all! This week, tell us how to hide and unhide objects in Access 2003 and Access 2007. There's more than meets the eye on this one, and Access 2007 has a neat trick that's easy to miss.


Tune in next Friday for our solution, along with a brand new Office Challenge.

About

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.

6 comments
dsunil
dsunil

what is access and how to use the access formulas what is the formula

lforbez
lforbez

Hide: Right click object| Hide in this group | Ok Unhide: Right click Menu Bar| Navigation Options|Show hidden Objects | Ok

ssharkins
ssharkins

Access is a desktop database application -- one in several products that make up the MS Office suite.

Tony Hopkinson
Tony Hopkinson

k = i * e Knowledge = intelligence * effort Given in your case i and e are much less than one, your solution is self evident.

Marshwiggle
Marshwiggle

... than the reply to Mr. Hopkinson that I was about to make.

coveycraig
coveycraig

Within the navigation panel, you can right-click an item, select "hide in this category or select "properties" and then check the "hidden" attributes box. You can go to database tools, click on Property Sheet in the toolbar, and then check the "hidden" attributes box. You can hide columns within a table simply by right-clicking the header and selecting "Hide". You can hide tabs by clicking the Office button, then "Access Options", "Current Database" and finally by unchecking the "Display Document Tabs" box. You can hide the message bar by going to the show/hide part of database tools and unchecking the "message bar" box. Finally, you can hide items using user-level security controls.

Editor's Picks