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:
=BCW_UPCA([item_barcode]) - 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.

Ready!
- Completed Labels ready for Printing.
