New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions Bookmark and Share
EStoddard

UPC-A Font with TrueType Windows Font Package


Okay, I have the system working in Access and creating bar codes, but I do not see how to create a UPC-A type barcode with the two options I have selected.

The one I am trying to generate has longer bars on the first, middle, and last bars. I believe when I look it up, it is a UPC-A, but what I generate is only equal sized bars with the 12 numbers below.

I also found later that I should add 2 zeros on the front end of my Database number but that still did not change anything.

So for my end result I want a UPC-A barcode to print on my Microsoft Access 2010 Report. It is sourcing my database, just not getting the barcode to look like a UPC-A Code.

Thanks for any help.

Any thoughts?


06-03-12     2637 day(s) ago    

  Report Abuse

 

Ben

Best Answer

Make sure that you are using UPCa and not UPCe.

Some tests that you can run:
1. Instead of applying the IDAutomationUPCEAN font, apply TimesNewRoman and then view the report in Report mode. What does the encoded data look like? It should be very similar to this attachment:

U(a08551*RNKKNm(W+=!}

2. If it does not look similar to the data above, as another test, hard code your value using:

=UPCa("00855173003019")

and see what the encoded data looks like.

Posted 2634 day(s) ago

()
()
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.
Other Answers (2)

EStoddard
Okay. Still not working. This is what I have set up.

I am trying to generate in a Microsoft Access 2010 Report a UPC-a barcode in a report.

I am using Microsoft Access 2010.
I am using the VBA Tool, imported into Access.
I have bought and installed the TruType for Windows Font.

The VBA appears loaded correctly.
The Fonts do show up as Font Selection.
I have formatted the Control Source as "=UPCa([Field])
It does Generate a barcode, but it does not look right at all.

-----------------------------------------------------------------------------------------
So I have a UPC number that is 12 digits.
I have led it with two zeros and even taken away the zeros.
My understanding was, this needs to be 14 digits.
Example: 00855173003019

The formatting in Access of this field may be the issue:
I believe that your software says I should format the field in the table as a number. The only way I can get it to hold integrity with the leading zeros is as text.

Is there a way to set up formatting as a number in Access to hold the 14 digits "as is"?

Thank you,
Earl Stoddard
I would love to talk with someone on this. 248-505-3395.

Posted 2635 day(s) ago

()
()
   Report Abuse

Ben
For an intro on UPC/EAN fonts, please view: https://www.idautomation.com/barcode-fonts/upc-ean/#video-tutorial

Barcode fonts, unlike fonts such as Times New Roman or Arial, require special formatting so that the data, when the barcode font is applied, will be scannable. This is true of most barcode symbologies with the exception of Code 39 and a few others. Formatting the data can involve adding start and stop characters or a check digit to the data; manipulating the data so that it is interleaved to create a smaller barcode; or converted to alternate characters that the barcode font can understand.

There are many types of barcode tools that will format data for a barcode, some tools are more automated than others.

Here is an example of a font encoder/font tool:
http://www.bcgen.com/fontencoder/

We have over 30 different font tools free to use with our fonts and you should be able to use one of the ones located at https://www.idautomation.com/font-encoders/ depending on which application you are using.

UPC(A and E) requires its data to be encoded using a Font Encoder. In Access, we have the VBA Macros (free font tool) that will encode your data: https://www.idautomation.com/font-encoders/vba-macro/

For a video on creating Barcodes in Access, please view:


The video explains how to generate Code 128. However, to generate UPCA or UPCE, you must type out the function for UPCA or UPCE using the functions list at: https://www.idautomation.com/font-encoders/vba-macro/#Barcode_VBA_Properties

=UPCa

=UPCe

Posted 2636 day(s) ago

()
()
   Report Abuse
Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2019 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook