leading zeroes being stripped

  • Thread starter Thread starter Stonewall
  • Start date Start date
S

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.
 
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
 
Back
Top