defaultvalue and zero suppression 2

[BitZero]

I have a combo box on a form so the user can select from a list of part numbers. It's an alpha/numeric field of length 10. I have this logic in the change event:

me.cmb_part.defaultvalue = me.cmb_part.value

This works just fine if the part number is something like AB123, or 12345. But if the part number is 01234, then what get's displayed as the default for the next record is 1234. The zero is suppressed. How can I prevent the zero from being suppressed? The format property is blank, and I'm using Access 2003.

Thanks

 

[RuralGuy]

Try:
me.cmb_part.defaultvalue = """ & me.cmb_part.value & """"

(RG for short) aka Allan Bunch MS Access MVP acXP ac07 winXP Pro
Please respond to this forum so all may benefit

 

[BitZero]

That worked! (and you can quote me on that)

Thanks

 

[RuralGuy]

Glad I could help.

(RG for short) aka Allan Bunch MS Access MVP acXP ac07 winXP Pro
Please respond to this forum so all may benefit