PDF 417 Barcodes in MS Access
PDF 417 Barcodes in Access
- This tutorial shows how to add PDF 417 barcodes to your MS Access reports. The barcodes are generated using BarCodeWiz PDF 417 Fonts.
Step 1. Import module with barcode functions
- Click on the Database Tools tab > Visual Basic (or press Alt + F11).
- Right-click the database and Import File....
- Select BarCodeWizPdf417.bas
- The default location of the file is:
Program Files\BarCodeWiz\BarCodeWiz PDF 417 Fonts\BarCodeWizPdf417.bas
- The following module should now be part of the Access file.
Step 2. Create a new table (or use an existing table)
- Create a new table with barcode data. Name the table Items (or simply use an existing table). Our table has the following data:
Step 3. Create a new report in Design Mode
- Click on Create tab > Report Design
Step 4. Set Record Source of the report
- Go to report Properties window and set the Record Source property to Items (the name of our table from step 2).
Important: Never use the same name for text box as your table field's name.
Step 5. Insert a TextBox for Barcode into the Detail section or the report. Set these properties:
- Control Source: =Pdf417Encode([item_sku],False,0,1,2,True,0,0)
NOTE: Full description of the variables is available in the comments in the module text.
- Can Grow: Yes
- Border Style: Transparent
- Font Name: BCW_PDF417
- Font Size: 3
NOTE: For smaller barcodes, you can set the point size as low as 2pt
Step 6. Print or Print Preview the report.
- The report is ready to save or print.
