Using calculated fields - Code 39

You can display and print calculated fields as bar codes using TrueType bar code fonts.

Note: Using calculated fields limits you to the Code 39 normal character set.

The Code 39 standard says that Code 39 bar codes must start and end with an asterisk character, like so;

*12345*

You can use the following calculated fields to print a field with asterisk characters at the start and end. You can also format the field values in the calculation;

Text fields

Simply print asterisk at the start and end using this calculation;

Combine('*', Upper(Fieldname), '*')

Numeric fields

See Lotus Approach Help for details about the NumToText( ) function;

Combine('*', NumToText(Fieldname, '0.00'), '*')

For bar codes without decimal places;

Combine('*', NumToText(Fieldname, '0'), '*')

For fixed width bar codes with 6 digits and leading zeros;

Combine('*', NumToText(Fieldname, '000000'), '*')

Date Fields

See Lotus Approach Help file for details about the DateToText( ) function;

Combine('*', DateToText(Fieldname, 'YYYYMMDD'), '*')

Boolean

To prints bar codes as YES or NO;

Combine('*', Upper(Fieldname), '*')

To print bar codes as Y for Yes and N for No;

If (IsBlank(Fieldname),'',Combine('*', If (Like(Fieldname),'Yes'),'Y', 'N'), '*'))

Fields containing spaces

Space characters are non-printing characters (they always print a blank gap). If your text fields contains space characters, to print the spaces correctly;

Combine('*', Translate(Upper(Fieldname),' ','_'), '*')

Fields that may be blank

If you want fields containing no data to print no bar code;

If(IsBlank(Fieldname),'', Combine('*',Translate(Upper(Fieldname),' ', '_'),'*'))