Hi Folks.
Apologies if this is not the right forum.
I'm working on a solution to scan barcodes into a table. I setup a form with a textbox and it's control source is tied to a field in my table. The scanner I'm working with is programmed to add characters to the scanned value so 012345 is presented as `012345` (notice the tic symbols). I want to remove those extra characters but I'm not sure how. So far I've tried adding
to the KeyPress and Enter events but it's not working. I'm thinking either I'm using the wrong event or my syntax is way off. Maybe something like
? I'm going to keep digging around but hope someone with a bit more knowledge than I can chime in here an show me the error of my ways. - Thank you in advance.
Apologies if this is not the right forum.
I'm working on a solution to scan barcodes into a table. I setup a form with a textbox and it's control source is tied to a field in my table. The scanner I'm working with is programmed to add characters to the scanned value so 012345 is presented as `012345` (notice the tic symbols). I want to remove those extra characters but I'm not sure how. So far I've tried adding
Code:
Barcode = Mid(Barcode, 2, Len(Barcode) - 2)
Code:
Barcode = Mid(txtBarcode.Value, 2, Len(Barcode) - 2)