Hello,

I have a problem printing barcodes; my reader will not detect the printed barcode. Others work and I do not usually have a problem but here I go.

I have a simply table with fields ‘Room’ and ‘Shelf’, then I have a form that print these for scanning. Once scanned we have a program that uploads the barcodes and puts them into the separate Room and Shelf fields within our database.

Here are the examples of code I have been trying to be able to capture the barcodes:

="*"+([Shelf!Room]+shelf([Shelf!Shelf]))+"*"

="*"+([Shelf!Room]& shelf([Shelf!Shelf]))+"*"

="*" & [Shelf!Room]+shelf([Shelf!Shelf]) & "*"

Any ideas would be greatly appreciated.

Thanks.

You need to use the start and end delimiters * for all 3of9 codes so it should be
="*" & [Shelf!Room]&shelf([Shelf!Shelf]) & "*"
also make sure that your scanner is programmed to decode 3of9 - you have to check your owners manual for that because they change between manufacturers and even models...