Create Barcodes in MS Access
Code 128 Barcodes in Access
- This tutorial shows how to add Code 128 barcodes to your Access Reports.
- See the video or simply follow the steps below.
![](https://media.barcodewiz.com/images/c0013cc0-3fb8-4eb7-8b66-3ad3ad611dda-C128-access_report_preview.png)
Step 1. Import module with barcode functions.
- Click on Database Tools tab > Visual Basic (or press Alt + F11).
![Open the Visual Basic Editor in Access to import BarCodeWiz Code 128 module](https://media.barcodewiz.com/images/4d9bf342-7978-4736-8294-a257260a632a-C128-access1.png)
- Right-click on the database name and select "Import File"...
![Right-click project name and select Import File to import BarCodeWizCode128 module](https://media.barcodewiz.com/images/289f76cf-f3f4-47bf-b6ef-e31af49568c7-C128-access2.png)
- Select BarCodeWizCode128Dll.bas.
- The default location of the file is:
C:\Program Files\BarCodeWiz\BarCodeWiz Code 128 Fonts .
![](https://media.barcodewiz.com/images/57c36e01-5a39-4849-b919-5b3b23a4a7e8-C128-access3b.png)
- The following module should now be part of the Access file.
![](https://media.barcodewiz.com/images/2584c2fb-2b49-4236-b1a4-82a5da279ad8-C128-access4b.png)
Step 2. Create a new 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/00067cde-9248-44ca-88b0-7fa5aa1f5225-access003.png)
Step 3. Create a new report
- Click on Create tab > Report Design
![](https://media.barcodewiz.com/images/ab8fbc1b-8143-4618-8562-87c0f68a8f4d-access005.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/3a7cb5e2-8d4a-456f-a766-144c00cea744-access006.png)
Step 5. Insert a TextBox for Barcode into the Detail section or the report. Set these properties:
- Control Source: =BCW_Code128B([item_barcode])
- Border Style: Transparent
- Font Name: BCW_Code128B_2
- Font Size: 24
- Font Color: #000000
Step 6. Add Item Name and Item Price
- Add two more Text Boxes and change their Control Source to item_name and item_price, respectively
![](https://media.barcodewiz.com/images/3af8983f-4f8a-409e-922d-46278cf0fb4c-access008.png)
Step 7. Print or Print Preview the report.
- The report is ready to save or print.
![](https://media.barcodewiz.com/images/340c5c88-d9e9-4d95-80f7-2d211b38a7a6-access009.png)