Barcodes in MS Access
- This example illustrates how to use BarCodeWiz ActiveX Control in a Microsoft Access Report.
- We are using an already existing inventory table (Items) for barcode data.
- Follow the steps below, simply or watch the video
![](https://media.barcodewiz.com/images/221e46e4-5d3f-4970-b197-a4de41e1d096-access2016_ax_39.png)
Step 1. Create a new Report
- Click on Report Design to create a new blank report.
- Want to add barcodes to an existing report? Simply open it in Design Mode here.
![](https://media.barcodewiz.com/images/a39591e2-7dfc-4c94-ad53-a4ce8e039090-access2016_ax_02.png)
Step 2. 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/e7c4e3fd-5ad6-4051-9e3d-81b5865c0bf6-access2016_ax_05.png)
Step 3. 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/ca6f45d2-324e-425d-9216-5dabbad9f373-access2016_ax_06.png)
Step 4. Update Record Source of the Report
- In the Property Sheet, select Report.
- Change the Record Source to Items (the name of our table).
Important: Never use the same name for text box as your table field's name.
![](https://media.barcodewiz.com/images/2f844338-cb78-4272-b2d1-547e29b2dff5-access2016_ax_07.png)
Step 5. Update Control Source of BarCodeWiz
- In the Property Sheet, select BarCodeWiz0.
- Change the Control Source to Barcode (the name of the column with barcode text in our table).
![](https://media.barcodewiz.com/images/b45b1b14-9499-484f-925e-c85995a2f5f3-access2016_ax_08.png)
Step 6. Optional: Insert additional text fields into the report.
![](https://media.barcodewiz.com/images/d8967bff-8a44-4b38-912e-33a2ba314588-access2016_ax_11.png)
Your report is ready!
- Click on Print Preview or Print to see your report.
![](https://media.barcodewiz.com/images/771317e9-0053-4c74-9319-07097c38f0b9-access2016_ax_12.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)