Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Barcode Formatting UCC /EAN 128

Barcode Formatting UCC /EAN 128

Barcode Formatting UCC /EAN 128


Not really sure where to ask this question,

I am trying to encode the following (00) 1 0123456 361586002 into a UCC /EAN 128 barcode label in my Report
The record source is from table called Delivery and uses the following three fields ( A1Code, GSI and PalletNo )

I have tried following examples below in the control source of the ActiveX Barcode and inputting the FNC1 character using the ASCII 202 character "Ê" at various position but still to no avail.

="00" & [A1Code] & [GSI] & "Ê" & [PalletNo]

="00" & [A1Code] & "Ê" & [GSI] & [PalletNo]

I have even tried removing the FNC1 character and inputting the following below in the control source but the barcode scanner is showing an error “invalid check digit”.

="00" & [A1Code] & [GSI] & [PalletNo]

Any assistance would be greatly appreciated,

RE: Barcode Formatting UCC /EAN 128

With Barcode Formatting UCC /EAN 128 you need to add a check digit. Hence reason your coming up with an error code. Create a function to generate a check digit code and run the function on your query which is the source code for your report that takes this control source below from:

You could try putting on you query for your report example, CheckDigit: MOD([A1Code] & [B] & [F])

="00" & [A1Code] & [B] & [F] & [CheckDigit]

MOD is the function called to generate the check digit.

Google examples of code functions to see how the check digit is generated in a EAN 128 barcode. There are examples out there.

RE: Barcode Formatting UCC /EAN 128


="00" & [A1Code] & [B] & [F] & [CheckDigit]

[B] = [GSI]
[F] = [PalletNo]


="00" & [A1Code] & [GSI] & [PalletNo] & [CheckDigit]

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close