Ignore leading zeros in combo box ?

[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.

 

[AlCamp]

Try using Val(BarCodeNumber) to convert the bardcode "text number" to a real
number. Then they should match.
hth
Al Camp