Printing a barcode access 2007


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.
 
Ad

Advertisements

B

barcodewiz

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
 
R

rap43

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.
 
Ad

Advertisements

Joined
Nov 29, 2012
Messages
1
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top