Microsoft Office Code 39 Barcode Tutorial
The Code 39 font is the easiest barcode symbology to use in Microsoft Office. Creating the barcode is as simple as appending the data with the start and stop characters of an asterisk (*) or exclamation point (!).
Check characters are used in high-density barcodes so that scanners can verify the barcode was properly read. Self-checking fonts such as Code 39 and Codabar have checking code built-in so that the calculation of check characters is not required. Self-checking fonts are easy to use in Microsoft Access and may be entered directly from the keyboard. If these self-checking barcode fonts cannot be used, refer to the Access Barcode Integration Guide for proper product suggestions.
For example, to create a barcode that encodes the data "1234ABCD" with the Code 39 Font, use the following formula =("!" & [Table.Field] & "!") in the control source field where Table.Field points to the table and field that contains the data to encode.
Tabs and returns may be added with Code 39 fonts (in extended39 mode) between fields from a Microsoft Access report by inserting =("!" & [Table.Field] & "!") in the control source field where Table.Field points to the table and field that contains the data to encode. The following Microsoft Access formula places a tab function (in extended39) between fields: =("!"&[DataField1] & "$I" & [DataField2] & "!")
Below is an example of the above formula in a text field on a report:
If a non-self-checking, high-density barcode is preferred, IDAutomation provides font encoders such as VBA Macro Functions that can be utilized in conjunction with IDAutomation fonts to automatically format the start, stop and check characters to the barcode fonts.
Self-checking barcode fonts such as Codabar (numbers) and Code 39 (numbers and uppercase letters) are the easiest to use in Excel when encoding numbers and/or uppercase letters. Self-checking fonts have checking code built-in so that the manual calculation of check characters is not required. If these self-checking barcode fonts cannot be used, refer to the Excel Barcode Integration Guide for proper product suggestions.
IDAutomation's self-checking barcode fonts may be generated as a calculated field in Excel. The following tutorial demonstrates how this can be achieved.
Tabs and returns may be added with Code 39 fonts (in extended39 mode) between cells by inserting "$I" (for a tab) or "$M" (for a return.) For example, the following formula encodes a tab between cells A1 and B1: =("*"&A1&"$I"&B1&"*")
Learn more about combining multiple cells into a single barcode.
IDAutomation's barcode fonts provide an easy method of barcoding an entire Excel column. Code 39 barcodes are created in an Excel spreadsheet in this example, with the IDAutomationC39 font that is included in the Code 39 Barcode Font Package. Codabar fonts may also be used to create smaller numeric-only barcodes. For fonts other than Codabar and Code 39, refer to IDAutomation's VBA Macro Tutorial for Microsoft Office or the Barcode Integration Guide for Excel.