Barcodes in Microsoft Access

Barcodes in Microsoft Access

The common method to print barcodes from within Microsoft^® Access™ is by using a report. The TBarCode Object need only be inserted once at the report definition. Therefore you need a table (query) which servers as data source for the report and a data field, that specifies the content of the barcode.

How to insert TBarCode OCX (as ActiveX Control) in a report?

Open a new report in design view. If you need a barcode for each record, then insert the ActiveX^® Control into the detail area and position it at the desired place.

Thereto you choose Insert - ActiveX Control in the main menu. You will see a list of all available elements, from which you select TBarCode.

The control will be inserted in the detail area. The detail area will be printed once for each record set in the table (or query).

How to control the content of the barcode in a report?

In design mode right-click the TBarCode - ActiveX^® Control. You will see a menu where you select Properties.

In the field Control Source located in the sub menu data you can define the content of the control. That means you can select the table or query field which is encoded as barcode.