Formatting entry in combo box

[pbuethe]

I have a combo box, cboFirstAdjTapeNbr. It is based on a field which is text but appears as a 7 digit number. Is there a way that I can enter the number without the leading zeroes and have it find the correct item? I want to do this so the users will have an alternative to picking from the combo box list (since it will get long) and not have to bother entering the leading zeroes (the current numbers range from 0000034 to 0000039). I want to be able to enter e.g. 37 and have it change it to 0000037 so it is found in the list. Whatever I have tried, I have gotten the message "The value entered isn't an item in the list."

Also, how can I make it initially display the last item, but still allow the user to select/enter a different number?

Thanks for your help.