Ignore leading zeros in combo box ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box containing hundreds of barcodes.
Whan a barcode is entered or selected, I need to populate several other
controls with data.
Most barcodes contain leading zeros but I want an entered value to match
regardless of the leading zeros. Is there any way to do this?
e.g. if the user enters 19426 I want it to pick up 019426 from the list.
 
Try using Val(BarCodeNumber) to convert the bardcode "text number" to a real
number. Then they should match.
hth
Al Camp
 
Back
Top