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