Using the Active Barcode Components in Access

Microsoft Access is a database that holds data in tables. When an Active Barcode Component is added to an Access Form or Report as an ActiveX control, the component's Properties list allows the user to select one of the Table fields as a Source of the components data - ie the data to appear in the barcode.

The Record Source may be selected from a drop-down list in the form or report's properties list, and the barcode's Control Source may be selected from the drop down list in the component's properties list. All other properties (code type, size, font, etc.) can be selected from the other entries in the Access Properties list at design time.

This allows barcode creation to be fully automatic for every record in a database.

Of course, a barcode image that is the same on every record may also be created - by ensuring that the Control Source entry on the component's properties list is empty, and the required data is entered for the Caption property.

A sample Access database is included with the distribution

 

 

Active Barcode Component properties for a barcode image on a form or report may also be set at run-time using Visual Basic module code to modify the control's properties.

 

More:

Using the Active Barcode Components in Word