Barcode Labels Wizard in MS Access
Create Barcode Labels using Microsoft Access Label Wizard
- This tutorial shows how to use the built-in Microsoft Access Label Wizard to create a page of Code 128 barcode labels
- Watch the video, or follow the steps below
![](https://media.barcodewiz.com/images/9c5f5489-9372-4894-8e06-3aa8a9d2eccc-C128-ACCESS-LABELS-thumb.png)
Step 1. Open Labels Wizard
- With your data table selected, navigate to the Create tab, then under Reports section select the Labels Wizard icon.
![](https://media.barcodewiz.com/images/9f4269a1-e046-4515-905b-b5f95b0af251-access_labels01.png)
Step 2. Edit Labels Using Label Wizard
- In this example, we are using the Avery 5163 label.
- Click Next
![](https://media.barcodewiz.com/images/79367047-bda7-4ce4-99e0-61a5159df21d-access_labels02.png)
- Use the Default options
- Click Next
![](https://media.barcodewiz.com/images/0d0e84fe-eade-4879-b6f9-dacb57fcc0db-access_labels03.png)
- Add available fields into the label using the > button.
- Important Note: After pressing >, press ENTER to make the next field go on a new line.
- Click Next
![](https://media.barcodewiz.com/images/bf2d9028-db03-4bb1-af5a-a931e07c321e-access_labels03_1.png)
- Use the Default options.
- Click Next
![](https://media.barcodewiz.com/images/1720a915-2df8-45ab-9919-df5049110ff5-access_labels03_2.png)
- Select Modify the label Design radio button.
- Click Finish to complete the Label Wizard.
![](https://media.barcodewiz.com/images/d30692a9-3979-4c25-88ef-8c00e1d8ead4-access_labels03_3.png)
Step 3. 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\BarCodeWizCode128Dll.bas
![](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 4. Edit Report Record Source
- Under the Design Tab, in the Tools Section, click on Property Sheet.
![](https://media.barcodewiz.com/images/2453b013-a943-42b9-a327-e2402e741dd7-access_labels06.png)
- Set the Record Source to the data table
- In this example, the Data Table selected is Items
![](https://media.barcodewiz.com/images/c4bd34ae-70ba-4a1d-8300-63071b3c42e5-access_labels07.png)
Step 5. Update Barcode Textbox Properties
- Select the item_barcode field in the design view, and set the control source by pressing the . . . button.
![](https://media.barcodewiz.com/images/79e07a1c-6b79-4de8-a412-426e08de457f-access_labels08.png)
- In the Expression Builder, navigate to Functions -> Database2 - > Font Functions and double-click on desired Code128 expression value.
- Note: Before you double-click an expression value, make sure the Entry box is empty.
- In this example, we are using Code128B expression, =BCW_Code128B()
- The data column from the items table added earlier is item_barcode, therefore, the full expression syntax is the following: =BCW_Code128B([item_barcode])
- Click OK
![](https://media.barcodewiz.com/images/7d115966-6138-44f1-b708-0b751e1867fb-access_labels09.png)
- Again, select the item_barcode field.
- Set the Font Name to a BarCodeWiz font of your choice, In this example the BCW_Code128B_3 font is used.
- Set the Font Size so that the text is readable, In this example the Font Size is 18.
![](https://media.barcodewiz.com/images/a13de014-42d0-4ead-9280-c7afed4e321d-access_labels10.png)
- Finally, navigate to the Design Tab, and under Views select Print Preview.
![](https://media.barcodewiz.com/images/96e77625-8eee-4ed7-b00c-96ea887c61df-access_labels12.png)
- Completed Labels ready for Printing.
![](https://media.barcodewiz.com/images/18a9ad74-c8e5-4bcd-bf42-e073d09129ae-access_labels13.png)