Create Barcodes in MS Access
How To Create Code 39 Barcodes in Access
- This tutorial shows how to add Code 39 barcodes to your MS Access reports. The barcodes are generated using BarCodeWiz Code 39 Fonts.
- Watch the video or follow the steps below.
![](https://media.barcodewiz.com/images/6341b469-5cca-474e-9e8a-704c7790f5f0-C39-access-thumb.png)
Step 1. Import module with barcode functions.
- Click on Database Tools tab > Visual Basic (or press Alt + F11).
![](https://media.barcodewiz.com/images/1bb8f876-2f88-45dc-a824-86802d21bca5-c39-access1.png)
- Right-click the database and Import File... .
![](https://media.barcodewiz.com/images/b88f4304-704c-45b1-a22d-b108273db24e-c39-access2.png)
- Select BarCodeWizCode39.bas.
- The default location of the file is:
C:\Program Files\BarCodeWiz\BarCodeWiz Code 39 Fonts\BarCodeWizCode39.bas
![](https://media.barcodewiz.com/images/d0e905f7-39e3-49cd-bf06-c64e4c02cde5-c39-access3.png)
- The following module should now be part of the Access file.
![](https://media.barcodewiz.com/images/2c150780-d6ec-4336-9603-47ee7c8787b7-c39-access4_1.png)
Step 2. Select a Table or Create a New One
- 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/d34b02a9-2c9a-41bd-bff8-88e05edb7113-code39_access3.png)
Step 3. Create a new report
- Click on Create tab > Report Design
![](https://media.barcodewiz.com/images/459ed61e-9a37-403c-adc5-9ff7cbf407c8-code39_access4.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/21c49a89-fdfa-4134-9704-ca21062ef25c-code39_access5.png)
Step 5. Insert a TextBox for Barcode into the Detail section of the report. Set these properties:
- Control Source: =BCW_Code39([item_barcode])
- Border Style: Transparent
- Font Name: BCW_Code39h_2
- Font Size: 24
- Fore Color: #000000
![](https://media.barcodewiz.com/images/0dc00123-7869-4655-875a-9351c9cfef0b-code39-access6_1.png)
Step 6. Print or Print Preview the report.
- The report is ready to save or print.
![](https://media.barcodewiz.com/images/cbbaf010-118d-4cdd-b96b-f39fc0689225-code39_access7.png)