Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Leading Zeros & Product # (2000/SR1)

    I am putting together a database for tracking inventory. The product code that I have to use is already set, I can't change it. It is always a 10 digit number. It almost always starts with "013" and I it almost always ends in "000". Is there a way that I can set up this product code so that when entering, you only have to enter the middle 4 digits but allow the user to go back and change the first or last three numbers when needed? Thanks.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Leading Zeros & Product # (2000/SR1)

    You would need to treat it as a text string to be certain to preserve the leading zeros, but an input mask with a default for the field would probably be the simplest approach. Otherwise you would need a text box to enter the middle four digits and then on update you would need to concatenate the result into a 10-digit number. Hope this makes some sense.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •