You're welcome Marc, The devil is in the details! ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Thursday, May 05, 2011 3:37 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Bar Codes
Thanks Dennis I learned something today, I kept missing the [-] on the format Marc From: Dennis McGrath<mailto:[email protected]> Sent: Thursday, May 05, 2011 3:20 PM To: RBASE-L Mailing List<mailto:[email protected]> Subject: [RBASE-L] - RE: Bar Codes you would need to create a variable with a definition something like this like this: vBarcode TEXT = (IFGT( custnum, 999, CTXT(custnum), FORMAT(custnum,'[-]000') )) Then use a variable barcode control. Numbers less than 1000 would have leading zeros. When they are scanned they would be entered this way but that would not hurt anything as they would be stored correctly (assuming you are scanning into an integer column. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Thursday, May 05, 2011 2:48 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Bar Codes Dennis Sorry to ask but I have never done that before, how do I do that in the Label report? The custnum filed contains 2,3,4....? It must be something simple Thanks Marc From: Dennis McGrath<mailto:[email protected]> Sent: Thursday, May 05, 2011 1:58 PM To: RBASE-L Mailing List<mailto:[email protected]> Subject: [RBASE-L] - RE: Bar Codes Try adding leading zeros to small numbers so the bar code will be long enough to scan. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected]<mailto:[email protected]> ________________________________ From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of MDRD Sent: Thursday, May 05, 2011 1:36 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Bar Codes Hi I just got a bar code scanner and I have been having fun adding bar codes to my app but I ran across 1 problem. The bar code is on the custnum filed, the bar codes are very small for the lower custnum's 2,3 4.. and will not scan but for the bigger numbers it work Great. I have tried Autosize checked and unchecked. What am I missing? thanks Marc
