Printing a barcode access 2007

  • Thread starter Thread starter rap43
  • Start date Start date
R

rap43

I need to print a label that has a scanable barcode, using access 2007 from a
report, the report has a barcode. I am using a standard 39 font I use the
same font in other application and it scan correctly, but out of access it
generates a different barcode with the same number and it will not scan. Dose
anyone no why and what is the cure.
 
Just a guess, but make sure you are adding asterisks around the text?
For example, if you'd like to encode
ABC123
.... you would enter it as:
*ABC123*

You can add those automatically in the Control Source of the text box,
like this:
="*" & [BarcodeField] & "*"
where BarcodeField is the name of the column the barcode text comes
from.

Alek Szymanski
http://www.barcodewiz.com
 
Thanks
I found if you access the property sheet of the text box and on the data tab
choose the Input Mask run the wizard the format with asterisks before and
after your font will output to the printer correct.

barcodewiz said:
Just a guess, but make sure you are adding asterisks around the text?
For example, if you'd like to encode
ABC123
.... you would enter it as:
*ABC123*

You can add those automatically in the Control Source of the text box,
like this:
="*" & [BarcodeField] & "*"
where BarcodeField is the name of the column the barcode text comes
from.

Alek Szymanski
http://www.barcodewiz.com


I need to print a label that has a scanable barcode, using access 2007 from a
report, the report has a barcode. I am using a standard 39 font I use the
same font in other application and it scan correctly, but out of access it
generates a different barcode with the same number and it will not scan. Dose
anyone no why and what is the cure.
Click to expand...
Click to expand...
 
Realise this is an old post but i need to do the same thing. Within my Form when I goto the DATA tab within control source, when i input ="*"& [item barcode]&"*" I get "#error"

Google give me options with using activeX, but prefer not to download or purchase, since this is for work.

Steps preformed.
1. built table
2. built form with wizard
3. built report to print out barcode from page.

Any thoughts I would be gvery greatful. sure its something simple i'm over looking.
 
Back
Top