Create QR Code 2D Barcodes in MS 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.
- See the video or simply follow the steps below.
![](https://media.barcodewiz.com/images/fec8d896-d3da-4941-9701-b18391fe2c81-QR-access_report_preview.png)
Step 1. Import module with barcode functions
- Click on Database Tools tab > Visual Basic (or press Alt + F11).
![](https://media.barcodewiz.com/images/b768420a-29f2-4d02-9a84-9ba541cf0127-qr-access2.png)
- Right-click the database and Import File....
![](https://media.barcodewiz.com/images/b502884a-2f7e-4c6d-a2b1-e52a6ade2b90-qr-access3.png)
- Select BarCodeWizQrCode.bas.
- The default location of the file is:
C:\Program Files\BarCodeWiz\BarCodeWiz QR Code Fonts\BarCodeWizQrCode.bas
![](https://media.barcodewiz.com/images/9bb82852-f8fb-48e0-8958-7eae81d865aa-qr-access4.png)
- The following module should now be part of the Access file.
![](https://media.barcodewiz.com/images/899e7b30-cbf8-45e1-9782-263014faae8c-qr-acces5_1.png)
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:
![](https://media.barcodewiz.com/images/b35729db-fde5-43eb-a524-32fa24b41526-qr-access6.png)
Step 3. Create a new report in Design Mode
- Click on Create tab > Report Design
![](https://media.barcodewiz.com/images/96e71538-1a84-4dc7-bb66-7acf25c04a04-qr-access7.png)
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).
Important: Never use the same name for text box as your table field's name.
![](https://media.barcodewiz.com/images/e26328ba-95bd-4176-a618-19c87fe415eb-qr-access8.png)
Step 5. Insert a TextBox for Barcode into the Detail section or the report. Set these properties:
- Control Source: =QrCodeEncode([item_sku])
![](https://media.barcodewiz.com/images/957c8c62-835a-4ce3-9278-d69ef2208775-qr-access9_1.png)
- Can Grow: Yes
![](https://media.barcodewiz.com/images/7e2c1406-1ee0-47ea-9b78-8f368e407285-qr-access10.png)
- Border Style: Transparent
- Font Name: BCW_QR
- Font Size: 8
![](https://media.barcodewiz.com/images/9a07d466-990e-4685-a00f-40fffc2d2218-qr-access11_1.png)
Step 6. Print or Print Preview the report.
- The report is ready to save or print.
![](https://media.barcodewiz.com/images/3c2744e5-e530-4bfb-834b-fb83e0edee40-qr-access12.png)