Barcodes and access reports (1 Viewer)

gary250950

New member
Local time
Today, 10:12
Joined
Feb 23, 2022
Messages
6
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.
 

Attachments

  • Barcode properties.jpg
    Barcode properties.jpg
    224.9 KB · Views: 256
  • Report view extra zeros.jpg
    Report view extra zeros.jpg
    86.1 KB · Views: 242

Minty

AWF VIP
Local time
Today, 10:12
Joined
Jul 26, 2013
Messages
10,369
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?
 

gary250950

New member
Local time
Today, 10:12
Joined
Feb 23, 2022
Messages
6
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.
 

Attachments

  • Trolley data source.jpg
    Trolley data source.jpg
    124 KB · Views: 229

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:12
Joined
May 7, 2009
Messages
19,230
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.
Snap15.png
 

gary250950

New member
Local time
Today, 10:12
Joined
Feb 23, 2022
Messages
6
Trying it now, Having to try all this between mending stuff!!! Many thanks, though.
 

gary250950

New member
Local time
Today, 10:12
Joined
Feb 23, 2022
Messages
6
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

New member
Local time
Today, 10:12
Joined
Feb 23, 2022
Messages
6
Hi, Thanks again. Any chance you could give me some further advice and explaination about using both the code and font.
 

Users who are viewing this thread

Top Bottom