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
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.
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
- Option B: Click Design Tab > Controls > ActiveX Controls
- Select BarCodeWiz Class and click OK
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).
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.
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).
Step 6. Optional: Insert additional text fields into the report.
Your report is ready!
- Click on Print Preview or Print to see your report.
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