IDAutomation Barcode Label Software is an easy-to-use WYSIWYG barcode label printing software application that prints barcodes, text and graphics on standard laser and inkjet printers, in addition to thermal transfer printers.
IDAutomation Barcode Label Software is built to run on any operating system that supports the Microsoft® .NET Framework (Although the Framework is no longer required in version 2009). It is compatible with Windows 98 and above, including ME, 2000, XP, 2003, 2008, Vista, 7, 8 and Windows 10.
By using the process outlined here, labels can be created that include barcodes, text and graphics. After the label is created, it can be saved and retrieved for later use. Create a Custom Label Video
Label Fields (Available only in 2009 or later versions) may be
used to simplify updates when multiple objects on a label use the same information.
For example, a text object and a barcode object may contain the same serial
number field that creates a unique incremented number for each label printed.
Label Fields may be constant values or incrementing numbers. Incremented number fields keep track of which numbers have been printed in previous print jobs, so that each label has a unique number. When the label is opened the next time for printing, the serial number fields begin incrementing at the next unused number.
This barcode label software can link to columns in Microsoft® Access, Excel or a CSV text file as a data source for a text or barcode object, which allows printing of labels from data in Excel and Access or from a file export from other software. IDAutomation's label software can also link to a custom embedded data source.
The Pro and RFID versions provide linking to multiple data sources, powerful database macros and support for additional data sources including ODBC, DSN, Oracle and SQL Server.
IDAutomation's barcode label software allows the user to create a database, which is embedded in the label data file itself. This allows data entry of several different custom values to be created on labels.
Properties may be adjusted by right-clicking on the object and choosing Properties.
The following is a list of common properties and their functions in each tab:
- Allows user to manually place the barcode in the design area and change the orientation.
- This is the data that is encoded in the barcode. Please note that some barcodes such as DataBar, IntelligentMail, UPC and EAN accept only numbers and a specific number of digits. Entering data that is incorrect for the barcode type may cause unpredictable results.
- Global append values will append a prefix or suffix to the value. For example, an incremented value of 101 and a prefix of TX will create a barcode encoding TX101 on label 1 and TX102 on label 2.
- The formula value creates the barcode from the VB syntax formula entered. For example, the formula of "TX" & 100 + L# will create a barcode encoding TX101 on label 1 and TX102 on label 2.
- The following is a list of what is supported:
& concatenate words
VBCRLF adds a new line
L# label number
T# total number of labels. Example: "This is label " & L# & " of " & T# produces This is label 2 of 5.
Date() returns the current date; for example 11/18/2010
- Label Fields:
LabelField(name) returns the value of the Label Field. Label fields may be incrementing serial numbers or static constant values and are created in the properties tab of the label (Edit - Properties - Label Fields). Available only in 2009 or later versions.
- External Data:
Field(col) returns the value in the linked data source for the column [col] of the current row. Example: Field(1)
FieldName(name) returns the value in the linked data source for the column according to the current row. Example: FieldName(FirstName). If a header row is linked in and two names are the same, the second name appends a "1", for example "CompanyName" and "CompanyName1". If one of the columns is blank, it will be referenced as F# where # is the column number. The linked Value Table displays the TableName of each item.
- Additional variables, macros and external database functions are available in the Pro and RFID versions of the software.
- Allows user to manually select the anchor point of the component.
- This is where the barcode height, width and margins are defined.
- Increasing the Bar Width (X dimension) will increase the width of the entire barcode. Because most barcodes require specific settings in this area, the barcode cannot be sized by dragging its edges in the design window. The default X dimension is 0.03 CM or about .012" or 12 mils. This value may need to be lowered if the scanner cannot read barcodes with small X dimensions. When working with a high-quality barcode scanner, this value can be decreased to obtain a higher density barcode.
- The measurement of mils is an industry standard that is 1/1000 of an inch.
- This tab defines applicable Barcode Properties:
- Size - the size of the symbol is changed by adjusting the barcode X Dimension and Height.
- Barcode Encoding - this is the type of barcode or the symbology. The default is Code-128, which encodes numbers, text and other information.
- Use Check Digit - automatically adds the check digit to the barcode. The check digit is required for all symbologies except Code 39, Interleaved 2 of 5, Industrial 2 of 5 and Codabar. When using symbologies that do not require the check digit, the check digit option may be disabled. In cases where the check digit is already provided in the data source, the check digit option may be disabled.
- Allows the ability to change or disable the text that is displayed next to the barcode.
- The Character Grouping field determines the number of characters between spaces in the text interpretation of the data encoded in the barcode. Default =0 (off); supported values are 3, 4 and 5.
- Allows changing the colors of the barcode, text and background.
When ApplyTilde is enabled in the "AUTO" setting for Code 128, additional capabilities are enabled:
To generate GS1-128, the parentheses or tilde methods should be used as described in the GS1-128 section of the Code 128 FAQ. For example, the SSCC18 data of (00)008012349999999997 may be encoded as a GS1-128 barcode using the parentheses (00)008012349999999997 or with the tilde ~21200008012349999999997.
Tilde capabilities are also available that allow calculation of the MOD
10 check digit, for example ~2120000801234999999999~m17.
VB script formulas may also be used if desired to achieve the same result:
"(00)" & "008012349999999997"
The format ~ddd may be used to specify the ASCII code of the character to be encoded. For example, Code~009Bar~013 will create a barcode that encodes Code<Tab Function>Bar<Return Function>. To find the values for other functions, refer to the ASCII chart. Functions can be viewed when scanned with the IDAutomation Scanner ASCII Decoder.
The Pro and RFID versions of the Barcode Label Software contains additional advanced features including VB scripting capabilities, additional database connectivity and support for MICR, DataBar (RSS), Composite, PDF417, Data Matrix and other 2D barcode types.
Operators Description Example Usage Output / := divide $labelsPerPage=5
"TotalPages =" & T#/$labelsPerPage
TotalPages=1 * := multiply L#/T# * 100 & "% done" 20% done & := concatenate words "Label " & "L# & "of" & T# Label 1 of 5 - := subtract "Labels left = " & T# - L# Labels left = 4 + := add "Next Label = " & L# + 1 Next Label = 2 VBCRLF := Carriage Return + Line Feed (adds a new line) "Line1" & VBCRLF & "Line2" Line1
Variables Description Example Usage Output L# := Label Number L# 1 T# := Total Number of Labels
(if an dataset is linked or embedded)
"This is label " & L# & " of " & T#
This is label 2 of 5.
$myVar := Custom variable called 'myVar' $myVar = "123"
Macros Description Example Usage Output Chr(charcode):= ASCII Number to Char
Returns the character associated with the specified charcode from the ASCII chart.
Chr(73) & Chr(68) & Chr(65) IDA Currency(exp,nl) := converts exp to a currency
exp := string; n := number of decimal places
Returns a number in the correct regional currency. Default decimal number is 2.
Currency(12,2) $12.00 InStr(haystack,needle) := returns the index of the needle (string being searched) in the haystack (string to be searched). "m is at " & Instr("IDAutomation",m)
$a = "24680"
$b = Instr($a ,"6")
"6 is at position " & $b
m is at 7
"6 is at position 3"
Len(source) := returns the length of [source] text. Len("IDAutomation") 12 Left(source,x) := returns the first [x] characters in
[source] starting from the left.
Left("IDAutomation",3) IDA Mid(source,x,y) := returns a substring of [source]
starting at position [x] of length [y].
Mid("IDAutomation",3,4) Auto Right(source,x) returns the first [x] characters in
[source] starting from the right.
Right("IDAutomation",6) mation The Right(source,x) macro may also be used to ensure zeros are appended to the beginning of a number field that must be a certain number of digits in length, such as the requirements for the 14 digit GTIN. Example: Right("00000000000000" & LabelField(UPC_Number),14) Number(source, [n], [paren], [group])
source := expression to convert
[n] := optional decimal places = 2
[paren] := optional parenthesis for negative numbers = False
[group] := optional group digits = True
Number(-1234.56789, 4, true)
Number(-1234.56789, 4, true, false)
If(test-condition, true-expression, false-expression) If evaluates the test-condition and if true (or 1) the true expression is evaluated, otherwise the false-expression is evaluated. $x = Right(L#,1)
$Result = (
if($x == "0", "Even",
if($x == "2", "Even",
if($x == "4", "Even",
if($x == "6", "Even",
if($x == "8", "Even", "Odd"))))))
L# & " is " & $Result
"1 is Odd"
"39 is Odd" if the label number is 39.
Valid Test Operators: Numeric evaluation is the default and lexical string evaluation fall back. == equal;
<> or != is not equal;
<= or =< is less than or equal;
>= or => is greater than or equal;
< less than and > greater than.
3 > 2
Date/Time Macros Description Example Usage Output Date() := the current date Date() 05/21/2015 Time() := the current time Time() 11:10 AM Year() := the current year Year() 2015 Month() := the current month Month() 5 MonthName() := the current month name MonthName() May Day() := the current day of the month Day() 21 DayName() := the current day name DayName() Thursday
Conversions Description Example Usage Output Mod10(int) := the GS1 MOD10 check character that is often used in SSCC-18, GTIN, GS1-128 and Data Matrix barcodes. Mod10(12345678901) 2 ISO7064(text) := the ISBT K check character according to ISO7064. ISO7064(W000007123456) D Base4(int1,optional int2) := returns base-4 where int1 is the number to convert to base-4 and int2 the number to add to each digit of the result to create an ASCII character, defaults to 48 Base4(500) & vbcrlf &
Base2(int1, optional int2) := returns base-2 where int1 is the number to convert and int2 is the number to add to each digit of the result to create an ASCII character, defaults to 48
This function may be used to create hidden, more secure barcodes with hidden text.
Base2(5) & vbcrlf &
Label Fields Description Example Usage Output LabelField(name) := returns the value of the Label Field. LabelField(SerialNumber) 1
External Data Description Example Usage Output Field(col) := the value in the linked data source
for the column of the current row
(The current row is defined as the label number)
Field(1) Joe Smith FieldName(name) := the value in the linked data
source for the column of the passed in name and
the current row
If a header row is linked in and two names are the same, the second name appends a "1", for example "CompanyName" and "CompanyName1". If one of the columns are blank it will be referenced as F# where # is the column number. The linked Value Table displays the TableName of each item.
FieldName(Age) 21 Table(id).Field(row,col) := Returns the value in the linked data source [id] corresponding to the respective [row] and [col]. Table(1).Field(1,1) Joe Smith Table(id).Rows := Returns the number of rows of linked data source [id]. Table(1).Rows 5 Table(id).Columns= count of columns in the
linked data source [id].
Table(1).Columns 2 NOTE: The linked data source (id) starts at 1. Columns are numbered from left to right and start at 1. Choose Value Type - External Database to preview the column numbers and associated data.
Additional example formulas:
Free product support may be obtained by reviewing the knowledgebase articles that are documented below and by searching the resolved public forum threads. Priority phone, email and forum support is provided up to 30 days after purchase. Additional priority phone, email and forum support may be obtained if the Priority Support and Upgrade Subscription is active.
| ©Copyright 2015
IDAutomation.com, All Rights Reserved.
Barcode Fonts | Components | Scanners | Support | Contact Us
Over 70% of Fortune 100 companies use IDAutomation's products to automate their businesses.