leading zeroes being stripped

[Stonewall]

I have a 2003 application with a form used to track product inventory. When
I scan a product barcode tt displays the product number in a text box on the
form. It works fine except it strips away leading zeroes. It also does this
if I scan the barcode directly into the product ID field in the table. I
need for the leading zeroes to remain. How can I accomplish this? The
product ID field is defined as number, Double and auto decimal places in the
table.

 

[Jeff Boyce]

Are you saying that the sequence of characters used to identify the product
are a "number"? You aren't "doing math" on them, are you? I suspect the
"product number" is really just a string of characters that happen to be
digits.

Change the data type in the table to text.

Regards

Jeff Boyce
Microsoft Office/Access MVP