Create Code 128 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 Code 128 barcode labels.
Import External data into Access

Step 1. Open Labels Wizard

  • With your data table selected, navigate to the Create tab, then under Reports section select the Labels Wizard icon.
Select BarCodeWiz file to import barcode functions

Step 2. Edit Labels Using Label Wizard

  • In this example, we are using the Avery 5163 label.
  • Click Next
Select FontFunctions from the list
  • Use the Default options
  • Click Next
Add data table with barcode text
  • Add available fields into the label using the > button.
  • Important Note: After pressing >, press ENTER to make the next field go on a new line.
  • Click Next
Create a new report in Design Mode
  • Use the Default options.
  • Click Next
Set record source of the report
  • Select Modify the label Design radio button.
  • Click Finish to complete the Label Wizard.
Text box properties

Step 3. Import BarCodeWiz Font Functions

  • Navigate to the External Data Tab, under Import & Link section select Access
Add more text boxes
  • Navigate to the BarCodeWiz Fonts folder located in My Documents
  • Default Path: \\User\Documents\BarCodeWiz Examples\Code 128 Barcode Fonts\barcodewiz.mdb
  • Click OK
Add more text boxes
  • Click on the Modules tab and make sure FontFunctions is present
  • Click OK
Add more text boxes

Step 4. Edit Report Record Source

  • Under the Design Tab, in the Tools Section, click on Property Sheet.
Add more text boxes
  • Set the Record Source to the data table
  • In this example, the Data Table selected is Items
Barcodes are generated in report

Step 5. Update Barcode Textbox Properties

  • Select the item_barcode field in the design view, and set the control source by pressing the . . . button.
Barcodes are generated in report
  • In the Expression Builder, navigate to Functions -> Database2 - > Font Functions and double-click on desired Code128 expression value.
  • Note: Before you double-click an expression value, make sure the Entry box is empty.
  • In this example, we are using Code128B expression, =BCW_Code128B()
  • The data column from the items table added earlier is item_barcode, therefore, the full expression syntax is the following: =BCW_Code128B([item_barcode])
  • Click OK
Barcodes are generated in report
  • Again, select the item_barcode field.
  • Set the Font Name to a BarCodeWiz font of your choice, In this example the BCW_Code128B_3 font is used.
  • Set the Font Size so that the text is readable, In this example the Font Size is 18.
Barcodes are generated in report
  • Finally, navigate to the Design Tab, and under Views select Print Preview.
Barcodes are generated in report
  • Completed Labels ready for Printing.
Barcodes are generated in report