We use cookies to provide you with the best experience and functionality on our website. By using our site you agree to this. read more >   

Access 2016, 2013
Barcodes in reports

EnterpriseInfoTo use this functionality you require the Enterprise Edition

Access 2016, 2013

Barcodes in an Access 2016, 2013 database report


Here we show you how to add a barcode into a Access database report 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:

Barcode, Access 2016, 2013


Next create a new report.

Barcode, Access 2016, 2013


Now add the ActiveBarcode control to the report. You must be in "Design Mode" to do this.

Barcode, Access 2016, 2013


Select the "Design" tab. Click on the button "Insert ActiveX control" from the range of "Controls".

Barcode, Access 2016, 2013


A dialog will show up:

Barcode, Access 2016, 2013


Select "ActiveBarcode" here and click OK. Now the barcode object will be placed in your report. This will be a standard barcode of EAN-128 type. This is the default type.

Barcode, Access 2016, 2013


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.

Barcode, Access 2016, 2013


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: QR Code, GS1/EAN-128, Data Matrix, GTIN/EAN-13, Code 39, GS1-Data Matrix, Code 128, PDF417, DUN-14, EAN-8, EAN-14, EAN-18, ISBN, ITF-14, NVE, PZN8, SCC-14, SSCC-18, ...

Now place and resize the barcode element for your needs.

Barcode, Access 2016, 2013


Next we bind the controls text property (the barcodes content) to the data field "Code" of the database. Select the "Design" tab. Click on the button "Property sheet" from the range of "Tools".

Barcode, Access 2016, 2013


Have a look for the entry "Control Source" and change it to "Code". This is the data binding:

Barcode, Access 2016, 2013


Now close the design mode and switch to report view:

Barcode, Access 2016, 2013


Watch the result:

Barcode, Access 2016, 2013


The barcode control is bound to the data base field and shows the code of the current data set as EAN-128 barcode.

One last hint: A report is designed in a lower resolution that it is using while printing. So it may be required that you create the barcode control with a much bigger font size than you would normally use. Otherwise the text line under the barcode may be very very small in your print.

This manual was created by Frank Horn

| Home | Shop | Download | E-Mail | Privacy Policy | Imprint | Version 6.4.0 |
Web DesignszBubble
Web design Frank Horn

Frank HornActiveBarcode Generator
Web design
Copyright Frank Horn
Lars SchenkActiveBarcode Object
Web- & server component
Command line
Copyright Lars Schenk

All trademarks and product names mentioned are the property of their respective owners.