Create Barcodes in Microsoft Access

Step 1. Import barcode functions

  • Click on External Data tab > Access.
Import External data into Access
  • Browse for barcodewiz.mdb. The default location of the file is :
    Documents\BarCodeWiz Examples\Code 128 Barcode Fonts\barcodewiz.mdb
Select BarCodeWiz file to import barcode functions
  • Select FontFunctions from the Modules tab and click OK.
Select FontFunctions from the list

Step 2. Create a new Table

  • Create a new table with barcode data. Name the table Items (or simply use an existing table). Our table has the following data:
Add data table with barcode text

Step 3. Create a new report

  • Click on Create tab > Report Design
Create a new report in Design Mode

Step 3. Set Record Source of the report

  • Go to report Properties window and set the Record Source property to Items (the name of our table from step 2).
Set record source of the report

Step 4. Insert a TextBox for Barcode into the Detail section or the report. Set these properties:

  • Control Source: =BCW_Code128B([item_barcode])
  • Border Style: Transparent
  • Font Name: BCW_Code128B_2
  • Font Size: 24
  • Font Color: #000000

Step 5. Add Item Name and Item Price

  • Add two more Text Boxes and change their Control Source to item_name and item_price, respectively
Add more text boxes

Step 6. Print or Print Preview the report.

  • The report is ready to save or print.
Barcodes are generated in report