Create Data Matrix 2D Barcodes in Microsoft Access

How To Create Data Matrix 2D Barcodes in Access

  • This tutorial shows how to add Data Matrix barcodes to your MS Access reports. The barcodes are generated using BarCodeWiz Data Matrix Fonts.
2D Barcodes in Access

Step 1. Import module with barcode functions

  • Click on Database Tools tab > Visual Basic (or press Alt + F11).
Import External data into Access
  • Right-click the database and Import File....
Select BarCodeWiz file to import barcode functions
  • Select BarCodeWizDataMatrix.bas.
  • The default location of the file is:
    Documents\BarCodeWiz Examples\Data Matrix Barcode Fonts\BarCodeWizDataMatrix.bas
Select FontFunctions from the list
  • The following module should now be part of the Access file.
BarCodeWiz DataMatrix Module

Step 2. Create a new table (or use an existing 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 in Design Mode

  • 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: =DataMatrix([item_sku])
Text box properties
  • Can Grow: Yes
Text box properties
  • Border Style: Transparent
  • Font Name: BCW_2D
  • Font Size: 8
Text box properties

Step 6. Print or Print Preview the report.

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