bar codes in Access 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a label where I need to convert the UPC field to barcode. Is
there a function in the design view that will allow me to do this? It needs
to have the check sum characters calculated and show.
 
I have created a label where I need to convert the UPC field to barcode. Is
there a function in the design view that will allow me to do this? It needs
to have the check sum characters calculated and show.
Click to expand...

You'll need to set the Font property of a report textbox to the appropriate
barcode font (there are many). If the barcode reader you're using didn't come
with a disk with fonts, try a Google search for "barcode fonts"; many are
free, but you'll need to determine which one you need.

John W. Vinson [MVP]
 
Thanks for the response.
I do have the barcode I need (Code 128ABhr b) but my problem is figuring out
how to have the checksums calculated and included in the barcode.
 
I do have the barcode I need (Code 128ABhr b) but my problem is
figuring out how to have the checksums calculated and included in
the barcode.
Click to expand...

Find out the algorithm and write a function that you pass the UPC
code but that returns the UPC code with the check sum, and then have
that function be the controlsource of your control.
 
I have imported the VB script to Access and using the following function as
my control source: =Bar128A([UPC]). It calculates a barcode but my scanner
does not recognize it. I don't get an access error when I run the labels so
I don't know if there is a problem with the way the function calculates the
code.
 
I have imported the VB script to Access and using the following
function as my control source: =Bar128A([UPC]). It calculates a
barcode but my scanner does not recognize it. I don't get an
access error when I run the labels so I don't know if there is a
problem with the way the function calculates the code.
Click to expand...

Your scanner doesn't recognize it at all, or it's not being
processed correctly when scanned? If you're taking in the value, you
need to strip off the checksum digit(s) in order to use the value.
 
Back
Top