Code 39 Barcode Labels Wizard in MS Access
Create Code 39 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 39 barcode labels.
- Watch our video, or follow the steps below.
![](https://media.barcodewiz.com/images/8407ba49-6f42-4f3f-bb25-cd9e61a2857b-C39-access-labels-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 on the database name and select "Import File"...
![](https://media.barcodewiz.com/images/2f35e84c-3fee-427e-9d9b-8a30ea95d57d-c39-access_labels03.png)
- Select BarCodeWizCode39Dll.bas.
- The default location of the file is:
C:\Program Files\BarCodeWiz\BarCodeWiz Code 39 Fonts\BarCodeWizCode39Dll.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/e1102807-a74a-46e1-b28d-ac1956fc0dee-c39-access_labels09.png)
Step 2. 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 3. 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/5fecd26d-e3a2-4a35-83f1-c1173678813a-c39-access_labels01.png)
- Use the Default options.
- Click Next
![](https://media.barcodewiz.com/images/58d7c51f-7331-4040-91cb-bf5bd64f84f3-c39-access_labels02.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 4. Edit Report Record Source
- Under the Report Design Tab, in the Tools Section, click on Property Sheet.
![](https://media.barcodewiz.com/images/9e17ad7c-8121-4bbe-8f93-7d82f3b4e921-c39-access_labels04_1.png)
- Set the Record Source to the data table
- In this example, the Data Table selected is Items
![](https://media.barcodewiz.com/images/1d56ff65-6080-4b7f-8e8c-af87a6ffb2d8-c39-access_labels05_1.png)
Step 5. Update Barcode Textbox Properties
- Switch to Design View.
![](https://media.barcodewiz.com/images/dec407e4-415c-405f-8ab6-af2275cb1b1d-c39-access_labels06.png)
- Select the item_barcode field in the report, and set the control source by pressing the . . . button.
![](https://media.barcodewiz.com/images/7c0adf75-d5a3-4e83-89a4-3126d1e9f1b8-c39-access_labels07.png)
- In the Expression Builder, navigate to Functions -> barcodewiz - > Font Functions and double-click on desired Code39 expression value.
- Note: Before you double-click an expression value, make sure the Entry box is empty.
- In this example, we are using Code39 expression, =BCW_Code39()
- The data column from the items table added earlier is item_barcode, therefore, the full expression syntax is the following: =BCW_Code39([item_barcode])
- Click OK
![](https://media.barcodewiz.com/images/54ad3bdf-3ea5-44c1-88f8-ede61ac9ea45-c39-access_labels08_2.png)
- Again, select the item_barcode field.
- Set the Font Name to a BarCodeWiz font of your choice, In this example the BCW_Code39_2 font is used.
- Set the Font Size as desired; in this example, the Font Size is 18.
![](https://media.barcodewiz.com/images/97132dad-b118-429c-9204-df7778f331d0-c39-access_labels10.png)
- Finally, navigate to the Design Tab, and under Views select Print Preview.
![](https://media.barcodewiz.com/images/7473fc07-fe92-464e-94e7-d97e08d786be-c39-access_labels11.png)
- Completed Labels ready for Printing.
![](https://media.barcodewiz.com/images/656bf3fd-abe7-44cf-ade0-bedeb52aeef0-c39-access_labels12.png)