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.
Step 1. Import module with barcode functions.
- Click on Database Tools tab > Visual Basic (or press Alt + F11).
Right-click on the database name and select "Import File"...
- Select BarCodeWizCode39Dll.bas.
- The default location of the file is:
C:\Program Files\BarCodeWiz\BarCodeWiz Code 39 Fonts\BarCodeWizCode39Dll.bas
- The following module should now be part of the Access file.
Step 2. Open Labels Wizard
- With your data table selected, navigate to the Create tab, then under Reports section select the Labels Wizard icon.
Step 3. Edit Labels Using Label Wizard
- In this example, we are using the Avery 5163 label.
- Click Next
- Use the Default options
- Click Next
- 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
- Use the Default options.
- Click Next
- Select Modify the label Design radio button.
- Click Finish to complete the Label Wizard.
Step 4. Edit Report Record Source
- Under the Report Design Tab, in the Tools Section, click on Property Sheet.
- Set the Record Source to the data table
- In this example, the Data Table selected is Items
Step 5. Update Barcode Textbox Properties
- Switch to Design View.
- Select the item_barcode field in the report, and set the control source by pressing the . . . button.
- 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
- 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.
- Finally, navigate to the Design Tab, and under Views select Print Preview.
- Completed Labels ready for Printing.
