Barcodes and access reports

[gary250950]

Hi, I'm having real trouble with a report that I want to put barcodes into. So I've created a report from a table, and in the report, created a unbound textbox, formatted to Interleaved 2of 5 which is the font I must use for this particular report. And the data is from the Trolley fields (Short number) That's the report design view I've attached. But in report view, my 8 digit number has now increased to 16 digits, a zero in font of each original digit. If I use a 128 or 39 font it works fine, just this font, which is the one I must use. I'm not an expert by any means, just trying the best I can.

 

[Minty]

That seems a bit strange. Have you checked that the font specification isn't designed to do that.
Although probably unrelated why is it unbound, surely it should be bound to the trolley field or at least a calculation based on it?

 

[arnelgp]

you use the Code and Font found here:

The 2 of 5 interleaved code (grandzebu.net)

 

[gary250950]

Thanks for the reply, If I use a barcode generator just to check the barcode it is the correct 8 digits. I actually believe it is bound to the Trolley field in the table. I have attached another screenshot, would appreciate it if you could confirm.

 

[arnelgp]

did you try the Code in the link i gave.
you must use both the code and the font on that link.

also the controlsource of your Unbound textbox should be:

=Code25I([Trolley])

on my test db, i tried to scan it on my phone camera, and
it did pass all.

 

[gary250950]

Trying it now, Having to try all this between mending stuff!!! Many thanks, though.

 

[gary250950]

did you try the Code in the link i gave.
you must use both the code and the font on that link.

also the controlsource of your Unbound textbox should be:

=Code25I([Trolley])

on my test db, i tried to scan it on my phone camera, and
it did pass all.
View attachment 98511

Hi, Thanks again. Any chance you could give me some further advice and explaination about using both the code and font.

 

[gary250950]

Hi, Thanks again. Any chance you could give me some further advice and explaination about using both the code and font.