Create UPC EAN Barcode Labels in Microsoft 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.

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. Import BarCodeWiz Font Functions

  • Click on External Data Tab > Access
Add more text boxes
  • Browse for the file barcodewiz.mdb. The default location is:
    Documents\BarCodeWiz Examples\UPC EAN Barcode Fonts\barcodewiz.mdb
  • Click OK
Add more text boxes
  • Click on the Modules tab and select FontFunctions
  • Click OK
  • Click Close in the next window.

Step 4. Edit Properties of Text Box

  • With the text box selected, open its property sheet.
  • Edit the Control Source property by clicking the ellipsis button (...)
Add more text boxes
  • 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:
    =BCW_UPCA(item_barcode)
  • Click OK to close the Expression Builder.
Barcodes are generated in report
  • 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.
Barcodes are generated in report
  • Select the text boxes and press Ctrl+E to center align.
Barcodes are generated in report

Ready!

  • Completed Labels ready for Printing.
Barcodes are generated in report