Question about entering numbers without 0 in the beginning

[Hema Selvan]

I have created database in which my first field in the table is item number which has more than 15 numbers. so I used Text instead of numbers. Item number is primary key to avoid duplication. but the problem is when I scan the numbers some start with 0 and some don't. it is accepting both. when I scan from the box it starts with 0. but same item if I scan by label it doesn't start with 0. so numbers are duplicating now. For instance when I scan from box, it is 089674534, but same item when I scan from label it shows as 89674534. We get chance to scan item more than 3 times. so this number should show as duplicating but just because it takes with 0 and without o, it takes same item as different number. Can anyone give me idea how i can enter without 0. do I have use any query or do some changes in properties. for instance even if i scan from box it should eliminate 0 and take only other following numbers.

[TheSmileyCoder]

A function such as this could strip the zero's for you.

Public Function Trim0(strInput as string) as String
Do while Left(strInput,1)=0
 strInput=mid(strInput,2)
Loop
Trim0=strInput
End Function

[Hema Selvan]

thanks for the reply. but can you please let me know where exactly i am sriting tis function?

[TheSmileyCoder]

You write this in a separate module. Then you can call the function from wherever you need it.