BarCodeWiz Logo

Barcode Labels Wizard in MS Access

Create Barcode Labels using Microsoft Access Label Wizard

  • This tutorial shows how to use the built-in Microsoft Access Label Wizard to create a page of UPC-A barcode labels
  • Watch the video or follow the steps below

Before you begin - Import module with barcode functions.

  • Click on Database Tools tab > Visual Basic (or press Alt + F11).

  • Right-click on the database name and select "Import File"...

  • Select BarCodeWizUPCEAN.bas.
  • The default location of the file is:
    C:\Program Files\BarCodeWiz\BarCodeWiz UPC EAN Fonts .

  • The following module should now be part of the Access file.

Step 1. Open Labels Wizard

  • With your data table selected, click on Create > Labels.

Step 2. Select Label

  • Select the layout (we are using the Avery 5162) and click Next .

  • Leave the default options selected and click Next.

  • Add the fields to the label.
  • Important Note: Ensure the item_barcode field is in a line by itself by pressing the ENTER key.

  • Click Next

  • Select Modify the label design and click Finish

Step 3. Edit Properties of Text Box

  • With the text box selected, open its property sheet.
  • Edit the Control Source property by clicking the ellipsis button (...)

  • Edit the expression as below.
  • In this example, we are using BCW_UPCA function, =BCW_UPCA()
  • The data column from our table is named item_barcode, therefore, the full expression is:
  • Click OK to close the Expression Builder.

  • Set the font to one of BarCodeWiz UPCEAN fonts. We are using BCW_UPCEAN_2 font with size 24pt.
  • Position the text boxes and resize to prevent text from being cut off.

  • Select the text boxes and press Ctrl+E to center align.


  • Completed Labels ready for Printing.