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.
![](https://media.barcodewiz.com/images/8f93fb32-be16-4a70-aa1f-f7b029edd325-dm_access_GS1_THUMB.png)
Step 1. Import module with barcode functions
- Click on the Database Tools tab > Visual Basic (or press Alt + F11).
![](https://media.barcodewiz.com/images/5fc8036f-7b68-408e-9f40-c8d119cddcda-dm-access1.png)
- Right-click the database and Import File....
![Import of BarCodeWiz Code128 module into access file](https://media.barcodewiz.com/images/cbd598ac-1801-454c-8bae-e6b5f5c70452-dm-access2.png)
- Select BarCodeWizDataMatrix.bas.
- The default location of the file is:
Program Files\BarCodeWiz\BarCodeWiz Data Matrix Fonts\BarCodeWizDataMatrix.bas
![](https://media.barcodewiz.com/images/a6fcecfb-132f-42a7-96bf-531619e46535-dm-access_3_1.png)
- The following module should now be part of the Access file.
![](https://media.barcodewiz.com/images/76316af5-682d-49cb-94bb-2f3755430dfd-dm_access_GS1_001.png)
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:
![](https://media.barcodewiz.com/images/4c3ca4b1-ef10-4b02-b434-9ac224e0a4ce-dm_access_GS1_002.png)
Step 3. Create a new report
- Click on Create tab > Report Design
![](https://media.barcodewiz.com/images/401e4c98-0004-4fa0-add2-7a4c5ae10a66-dm_access_GS1_003.png)
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.
![](https://media.barcodewiz.com/images/8f794532-4bce-49f6-b551-12eb0ab25d80-dm_access_GS1_004.png)
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
![](https://media.barcodewiz.com/images/b57025da-87cf-4596-be33-602a76aeb76c-dm_access_GS1_005.png)
Step 7. Print or Print Preview the report.
![](https://media.barcodewiz.com/images/127d7394-838b-45d5-acde-caa4bde22e7a-dm_access_GS1_006.png)