Sending print commands in access

[Rogerhar]

I want to print bar codes in access 2000 reports. I want to use the bar code that's in the Tally Printer I am using. The manufacture suggested this code:

10 REM code 39 barcode
20 LPRINT CHR$(27);"[?11~";
30 LPRINT CHR$(26);" F3;111";CHR$(25);
40 LPRINT CHR$(20);"*123*";CHR$(20);
50 LPRINT CHR$(27);"[?10~"


I tried this in a text box with the font set to "Free 3 to 9":
=Chr$(27) & Chr$(91) & Chr$(63) & '11' & Chr$(126) & Chr$(26) & ' F3' & Chr$(59) & '111' & Chr$(25) & Chr$(20) & Chr$(42) & ([iSaleID]) & Chr$(42) & Chr$(20) & Chr$(27) & Chr$(91) & Chr$(63) & '10' & Chr$(126)

Any thoughts?


Roger

 

[ChrisO]

I’m not sure what the question is but did it work or not?

Never used bar codes before and it didn’t display correctly on the Report using the 'Free 3 of 9' but it looks like it worked using the 'Free 3 of 9 Extended' font.

But I can’t test it so there’s an A97 demo attached.

But I don’t know anything else about bar codes.

 

[Scooterbug]

I print off barcodes on all of our order forms. All I do is change the font to Free 3 of 9 Extended. At least for me, the only thing I have to add on to make it readable by a barcode scanner is an * at the beginning and end. I generally add the * in the underlining query, so it would look like this:

EnhancedSku: "*" & [SkuNumber] & "*"

 

[Rogerhar]

That works for me too. But the problem I am having is that I am using a 24pin dot matrix printer, and the bar code is not crisp enough for the OCR software I am using. So the code I posted is supposed to widen the white space in between the bars.

 

[ChrisO]

Roger.

Who are you replying to?
Your first question didn’t mention adding greater white-space between the bars.
What have you added to increase it?
Are you using "Free 3 of 9" or "Free 3 of 9 Extended”?

 

[Rogerhar]

Roger.

Who are you replying to?
Your first question didn’t mention adding greater white-space between the bars.
What have you added to increase it?
Are you using "Free 3 of 9" or "Free 3 of 9 Extended”?

I have tried them both, and the OCR software I am using could not read them. The problem is that the bar code that prints on my invoice is not crisp enough. I wanted to try and space the bars out so the OCR software had a better chance of scanning.

 

[paulino9]

that sounds more like a printer problem