Create barcodes in MS Access

Add Code 128 barcodes to your own Microsoft Access report.

Step 1. Import barcode functions: Click on External Data tab > Access and browse for barcodewiz.mdb. The default location of the file is:

 C:\Program Files\BarCodeWiz Code 128 Fonts\Examples\barcodewiz.mdb

Import External data into Access

Select BarCodeWiz file to import barcode functions

Step 2. Select FontFunctions from the Modules tab and click OK.

Select FontFunctions from the list

Step 3. Create a new table with barcode data. Name the table Items.  (or simply use an existing table)

 Our table has the following data:

Our data table with barcode text

Step 4. Create a new report: Click on Create tab > Report Design

Create a new Access report in Design mode

Step 5. Set the Record Source property of the Report to Items (the name of our table).

Update the Record Source of the report

Step 6. Insert a Text Box into the Detail section of the report. Change these properties:

     Control Source:

=BCW_Code128B([item_barcode])

     Border Style:

Transparent

     Font Name:

BCW_Code128B_2

     Font Size:

24

     Font Color:

#000000

 

 Add two more Text Boxes and change their Control Source to item_name and item_price, respectively.

Edit properties of the text box to show barcodes

Step 7. The report is now ready to save or print.

Report generated with Code 128 barcode fonts