How To

How to Create Labels From Microsoft Access Reports

By eHow Computers Editor
Rate: (13 Ratings)

One of the most convenient Access features for many a user is automatically printing mailing labels from your database. The labels are really just a kind of report. These instructions apply to MS Access 97.

Difficulty: Moderately Easy
Instructions

Things You'll Need:

  1. Step 1

    Open the Database window.

  2. Step 2

    Click on the Reports tab.

  3. Step 3

    Click New. A dialog box appears.

  4. Step 4

    Click Label Wizard.

  5. Step 5

    Locate the table or query that is to be used for the labels.

  6. Step 6

    Click OK.

  7. Step 7

    Follow the wizard's instructions to select the fields and formatting used in the labels.

  8. Step 8

    Print your labels when you are satisfied with the result.

Tips & Warnings
  • If you're not fully satisfied with the wizard's work, you can customize the look of your labels in Design view.

Comments  

jimlemon said

Flag This Comment

on 1/15/2007 I found that the values entered in Page Setup for columnar labels did not correspond to the printed labels. To ensure that the printed pages conform to these values, the height of the detail field must be set to the same height as that in the Page Setup - Columns dialog.

Post a Comment

Post a Comment

Have you done this? Click here to let us know.

I Did This

Related Ads

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.

eHow Computers
eHow_eHow Technology and Electronics