Prevent Access form labels from printing

by Mary Ann Richardson | May 02, 2006 7:00:00 AM

Tags: Microsoft Office, printing, Mary Ann Richardson, Microsoft Access, Microsoft Office Suite Access Tips Newsletter

Takeaway: Labels in Access documents may be helpful in conveying instructions, but some things are best left onscreen. Mary Ann Richardson shows how to keep Access form labels from winding up on your printout.

A quick-and-easy way to explain how to work with an Access form is to place the instructions in a label control. However, you probably would not want the instructions to appear when you print the form. When you need to have a label display on the screen but not on the printout, follow these steps:

1. Open the form in Design view.
2. Click the Label tool in the Form's toolbox.
3. Click and drag in the form where you want the label to appear.
4. Enter the instructions for the user.
5. Right-click the Label control and select Properties.
6. In the All tab, click Display When and select Screen Only from the drop-down list.

Your users will be able to read the instructions as they work with the form, but they will not be able to print the instructions with the form records.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.