Combo Box Zero Fill

[dgriffin]

I have a form with a combo box that zero fills for customer number. The problem is when they key in 26 it finds customer 260001 instead of just taking the 26 and zero filling so that its 000026. I have CUSTNO_COMBO = Right("000000" & CUSTNO_COMBO, 6) in the after update. Is there a way I can get this to happen?



Thanks
Darlene

[June7]

What method are you using for the search? Show full code.

[orange]

I have CUSTNO_COMBO = Right("000000" & CUSTNO_COMBO, 6) in the after update.

And what exactly do you think this does?

Are you trying to do something like
CustNumJustified = Format(CustNo,"000000") ???