# Suppressed "0"

Posted by WCWNG on February 12, 1998 at 22:00:52:

Hi Wu/NG,

Here is my another problem:
I've converted a Clipper's dbf to Access's MDB for vb6, and
the Ref_No is a 5 digit text field. Access will not allow to
reset its property as auto-number field if it has data on it.
I have no problem to get it incrementing 1 for a new record, but
the left most 0 has suppressed. For instance, the last Ref_No
is 01234[after converted from dbf to mdb], the new Ref_No shall
be 01235 [from Vb]. But I displays and saves as 1235 instead of 01235.
How can I control the left most 0? Any code sample will be
greatly appreciated. Thanks in advance!

WCW NG

Follow Ups:

- 看不太懂 小吴 18:42:31 2/17/98 (1)
  - Re: 看不太懂 wng 21:30:02 2/23/98 (0)