Access 2007 To use this functionality you require the Enterprise Edition
Barcodes in an Access 2007 database formular
Here we show you how to add a barcode into a Access database and bind it to a data field. First launch Access and create a new database or open an already existing database in what you want to add a barcode. A simple database could look like this:
Next create a new form. This is easy and we do not explain this functionality of
Access further. If you have questions about this, please have a look into the Access Online Help
The following dialog will appear:
Select "ActiveBarcode" here and click OK. Now the barcode object will be placed in your form. This will be a standard barcode of EAN-128 type. This is the default type. Now you can modify this barcode. You can change the type, text, colors etc. For this click inside the barcode with the right mouse button. A pop up menu will open. Select "ActiveBarcode-Object" and then "Properties...". The property dialog of ActiveBarcode will open. Here you can modify the barcode as you like. For example you can change the type to any barcode type supported by ActiveBarcode: For example: Code 25 Interleaved, Code 39, Code 128, Data Matrix, EAN-8, EAN-13, EAN-18, EAN 128, GS1-128, GS1-Data Matrix, GTIN-8, GTIN-12, GTIN-13, Bookland, ITF-14, PDF417, QR Code, SCC-14, SSCC-18, UCC-128, UPC-A, UPC-E.
Next we bind the controls text property (the barcodes content) to the data field
"Productnumber" of the database.
Have a look for the entry "Control Source" and change it to "Productnumber". This is the data binding:
Now close the design mode of the form and watch the result by simple opening the form:
The barcode control is bound to the data base field and shows the product number of the current
data set as EAN-128 barcode.
This manual was created by Frank Horn
Control / OCX