Create Barcodes in MS Access
- This tutorial shows how to create UPC-A barcodes in Microsoft Access using BarCodeWiz UPC EAN Fonts.
- To learn how to do that watch the video or follow the steps below
![](https://media.barcodewiz.com/images/5cdf506e-e989-4756-8241-4408c6c67cfb-UPC-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/a749c1a5-f23a-4f95-85bf-203a2e279afe-upcean-access1.png)
- Right-click on the database name and select "Import File"...
![](https://media.barcodewiz.com/images/d537aac4-f257-4b86-a7f9-00c1af13dc99-upcean-access2.png)
- Select BarCodeWizUPCEAN.bas
- The default location of the file is:
C:\Program Files\BarCodeWiz\BarCodeWiz UPC EAN Fonts
![](https://media.barcodewiz.com/images/0014eb93-51f6-4b81-bc0b-ec076a16e5e1-upcean-access3.png)
- The following module should now be part of the Access file
![](https://media.barcodewiz.com/images/b0e1c49f-5d90-433a-a51a-6e8591a6370f-upcean-access4_1.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/7524b680-4ecf-4315-a1c2-ceea8071a341-UPC-ACCESS-001.png)
Step 3. Create a new report
- Click on Create tab > Report Design
![](https://media.barcodewiz.com/images/16befe89-f2bd-403e-af67-f4a827a8ff91-a5.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/0fed281b-e4da-42b7-bb83-2a37bc5eb978-a6.png)
Step 5. Insert a TextBox for Barcode into the Detail section or the report. Set these properties:
- Control Source: =BCW_UPCA([item_barcode])
- Border Style: Transparent
- Font Name: BCW_UPCEAN_1
- Font Size: 48
- Font Color: #000000
![](https://media.barcodewiz.com/images/1379c14f-09aa-43a2-be1e-8c4e43e59a32-a7.png)
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
Step 7. Print or Print Preview the report.
- The report is ready to save or print.
![](https://media.barcodewiz.com/images/2388d695-6e24-42f5-8256-9fea28d89265-a8.png)