Create QR Code 2D Barcodes in Microsoft Access

How To Create QR Code 2D Barcodes in Access

  • This tutorial shows how to add QR Code barcodes to your MS Access reports. The barcodes are generated using BarCodeWiz QR Code Fonts.
QR Code 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 BarCodeWizQrCode.bas.
  • The default location of the file is:
    C:\Program Files\BarCodeWiz\BarCodeWiz QR Code Fonts\BarCodeQrCode.bas
Select BarCodeWizQrCode.bas
  • The following module should now be part of the Access file.
BarCodeWiz QrCode 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 4. 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 5. Insert a TextBox for Barcode into the Detail section or the report. Set these properties:

  • Control Source: =QrCodeEncode( [item_sku], 1, 1 )
    This sets the value of the barcode to [item_sku], symbolSize to 1, and errorCorrectionLevel to 1(L).
Text box properties
  • Can Grow: Yes
Text box properties
  • Back Style: Transparent
  • Border Style: Transparent
  • Font Name: BCW_QR
  • Font Size: 6
Text box properties

Step 6. Print or Print Preview the report.

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