Barcode font with Mail Merge (1 Viewer)

travismp

Registered User.
Local time
Today, 13:40
Joined
Oct 15, 2001
Messages
386
I am using a special font called Interleaved 2of5. You have to have macros enabled and the font package installed to get this font package to work. I have everything working perfect, I can print reports directly out of Access with the bar code perfect.

Here is my question:

Can anyone figure out how to get this to work in a query?

We have a couple mail merge documents set up in Word and I would like this same bar code to be at the top of the page.

I cannot find a way to get the BarCode to work in a query, only the report. I do not know if this is possible. Here is a sample database that comes with the program.
 

Attachments

  • Access 2000 Barcode Macros.zip
    167.4 KB · Views: 121

KeithG

AWF VIP
Local time
Today, 05:40
Joined
Mar 23, 2006
Messages
2,592
Is there a function you use to convert the data to a barcode? If so have you tried this function in a query?
 

travismp

Registered User.
Local time
Today, 13:40
Joined
Oct 15, 2001
Messages
386
the "control source" in the report looks like this:

=I2of5([TestData.NumberData])

Does this answer your question?
 

KeithG

AWF VIP
Local time
Today, 05:40
Joined
Mar 23, 2006
Messages
2,592
did you try using that expression in as a query column?
 

travismp

Registered User.
Local time
Today, 13:40
Joined
Oct 15, 2001
Messages
386
I just tried that a minute ago and I think I am making some progress. I think I might have it figured out. I will check back of what I am working on now fails. Thanks so far.
 

Users who are viewing this thread

Top Bottom