Barcode Scanning

[Aaron]

I have a barcode font that needs "*" in front and behind the data to work.
If I have a report that has a Name and control source of "PN", how can I add
these easy?

Thanks, Aaron

 

[Al Campagna]

Aaron,
Not sure what you want to do.
Are you saying you want to concatenate the asterisks onto the PN.
If so....
= "*" & PN & "*"
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Aaron]

Yes, a start and stop for the barcode. I used the exact formula below and
it print error. I found a forum that says to use a active X control for
barcodes but.. $700.. WOW

 

[Rick Brandt]

Yes, a start and stop for the barcode. I used the exact formula
below and it print error. I found a forum that says to use a active
X control for barcodes but.. $700.. WOW

Nonsense. What Al suggested should work fine as I have used that for years
with a simple barcode font. You most likely made a typo when you entered
it.

 

[Tony Toews [MVP]]

Yes, a start and stop for the barcode. I used the exact formula below and
it print error. I found a forum that says to use a active X control for
barcodes but.. $700.. WOW

What Rick said. You likely have a typo.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/