BarCodeWiz Logo

Create GS1 Data Matrix Barcodes in MS Access

How to create GS1 Data Matrix Barcodes in Access

  • This tutorial shows how to add GS1 Data Matrix barcodes to your MS Access reports. BarCodeWiz Data Matrix Fonts are being used to create the barcodes.
  • See the video or follow the steps below.

Step 1. Import module with barcode functions

  • Click on the Database Tools tab > Visual Basic (or press Alt + F11).

  • Right-click the database and Import File....
Import of BarCodeWiz Code128 module into access file

  • Select BarCodeWizDataMatrix.bas.
  • The default location of the file is:
    Program Files\BarCodeWiz\BarCodeWiz Data Matrix Fonts\BarCodeWizDataMatrix.bas

  • The following module should now be part of the Access file.

Step 2. Create a new Table

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

Step 3. Create a new report

  • Click on Create tab > Report Design

Step 4. Set Record Source of the report

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

 Important: Never use the same name for text box as your table field's name.

Step 5. Insert a TextBox for Barcode into the report. Set these properties:

  • Control Source: =GS1DataMatrixEncode([item_barcode],1,True,4)
  • Border Style: Transparent
  • Font Name: BCW_DM
  • Font Size: 2

Step 7. Print or Print Preview the report.

GS1DataMatrixEncode Parameters