Software

Office challenge: How do you get rid of labels when inserting controls into an Access form?

This week's Office challenge tests your knowledge of Access controls and reveals the answer to last week's challenge on protecting Excel workbooks.

When you insert new controls into a form, Access includes a label control. Depending on your conventions, you might not use those labels, which means extra work for you because you have to delete them. Luckily, you can inhibit those labels. Do you know how? Last week we asked… How do you password-protect an Excel workbook? Thanks to everyone for the great conversation. OurITLady, LAWRENCE KINUTHIA, Super_sonix, Neon Samurai, and Darryl all provided the right instructions:

  1. From the Tools menu, choose Options.
  2. Click the Security tab.
  3. Enter the password(s) for opening and/or modifying the workbook.
  4. Click OK.
In Excel 2007, click the Office button and choose Save As. In the Save As dialog box, click Tools and then General. A special thank you to Neon Samurai and Darryl for such informative responses. Setting a password is a simple process, but protecting your data is a complex subject.

About Susan Harkins

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.

Editor's Picks

Free Newsletters, In your Inbox