Barcode Labels in MS Access
Create Barcode Labels in Access
- Microsoft Access includes a built-in wizard for printing many common label layouts
- This tutorial shows how we can use it to create barcode labels
- Follow the steps below, or watch the video, to add barcodes to your own report
![](https://media.barcodewiz.com/images/5e205902-5f11-4634-adfc-d898e166a809-AX-access-000.png)
Step 1. Open the Labels Wizard
- In Object Browser, click on the data table you'd like to use for our barcodes. Our table here is named Items.
- Click on Create > Labels.
![](https://media.barcodewiz.com/images/209f29d4-21a5-44b7-acf1-99fcdf97f2dc-access2016_ax_14.png)
Step 2. Select the label layout and click Next.
- We are selecting Avery Label #8162 here.
![](https://media.barcodewiz.com/images/cd78e235-1525-4045-96e2-10566df547c5-access2016_ax_25.png)
Step 3. Click Next.
![](https://media.barcodewiz.com/images/0f1d96aa-c665-44c9-a4da-450bf81a0487-access2016_ax_26.png)
Step 4. Add one or more text fields to the label.
- Add any text field to the label (This is necessary to continue). We will remove it later.
![](https://media.barcodewiz.com/images/c561d36a-ced2-4dc5-a713-b95886450367-access2016_ax_27.png)
Step 5. (Optional) Select fields to sort by.
![](https://media.barcodewiz.com/images/af99503d-5be2-478e-91fb-c091b9bfbbd8-access2016_ax_28.png)
Step 6. Select Modify the label design and click Finish.
![](https://media.barcodewiz.com/images/f8bcf41b-1590-4cb2-98d2-af32948589f5-access2016_ax_29.png)
Step 6a. Our label so far.
- You may now delete the field(s) we added in Step 4. To do that, select the text box and press delete.
![](https://media.barcodewiz.com/images/a4ca4e33-a4a6-4849-9670-ad7fb081e791-access2016_ax_30.png)
Step 7. Add BarCodeWiz to the Report
- You might see one of two options, depending on size of your MS Access window:
- Option A: Click Design Tab > DOWN Arrow > ActiveX Controls
![](https://media.barcodewiz.com/images/d33fb970-98b5-41df-9411-2845d0dff1fd-access2016_ax_03.png)
![](https://media.barcodewiz.com/images/cc29e62d-392f-4609-8342-346092917370-access2016_ax_04.png)
- Option B: Click Design Tab > Controls > ActiveX Controls
![](https://media.barcodewiz.com/images/6724a7fb-9336-41da-b71d-0ebf953198e6-access2016_ax_31.png)
- Select BarCodeWiz Class, and click OK
![](https://media.barcodewiz.com/images/994c0f78-2077-42e9-834c-ea0a925e8115-access2016_ax_32.png)
Step 8. Ensure barcode is not cut off
- This step is necessary to prevent unreadable barcodes. It ensures the barcodes are not cut off if the barcode expands past the edges of the control.
- Resize the control to make it as wide as possible (this depends on your data).
![](https://media.barcodewiz.com/images/70c6301e-f9f0-4b0b-8ce5-b9664b67acd6-access2016_ax_33.png)
Step 9. Center the barcode if desired
- Set ControlAlignment to Top Center.
![](https://media.barcodewiz.com/images/fc8a8010-b336-4293-9f95-3e0360a0546c-access2016_ax_34.png)
Step 10. Update Control Source of BarCodeWiz
- In the Property Sheet, select BarCodeWiz.
- Change the Control Source to Barcode (the name of the column with barcode data in our table).
![](https://media.barcodewiz.com/images/f8cb8a43-7cb4-498d-b469-f980f4577433-access2016_ax_35.png)
Step 11. Optional: Insert additional controls into the report.
- Here we added two text boxes and a rectangle around the fields.
![](https://media.barcodewiz.com/images/e27d7fd6-7e8e-4e4c-aa41-70af41f0a71a-access2016_ax_36.png)
Ready!
- Click on Print Preview or Print to see your report.
![](https://media.barcodewiz.com/images/0b0c7ab8-9def-47aa-9d32-a9f7d84f8756-access2016_ax_38.png)
- If you see the error Some data may not be displayed, simply ignore it.
![](https://media.barcodewiz.com/images/0e949dd1-fb8a-4578-a405-55f0dcab5498-access2016_ax_37.png)
Want to see more Access examples with barcodes?
- BarCodeWiz ActiveX comes with a number of Access examples. See:
Documents\BarCodeWiz Examples\Barcode ActiveX Control\barcodewiz.mdb
![](https://media.barcodewiz.com/images/6635ca31-4202-4b58-b5c1-17d07e7cf0c6-access2016_ax_40.png)