Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Kansas, USA
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    taking out a character (Access2000 SR1a)

    I am working on a form where we will imput barcodes and sku #. I have a combo box where I will enter in the barcode from a handheld scanner. The scanner is programmed to put a semicolen ([img]/forums/images/smilies/wink.gif[/img] in front of the barcode number so that another program we use can tell that it's a barcode number and not a sku#. For this application, I need to take out the semicolen before the combo box is updated. What code would I use to do that?

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: taking out a character (Access2000 SR1a)

    The MID functions returns a specific number of characters from a text string starting at the position you specify. So try :

    MID(yourtext,2,numberofchars)

    If there are both SKUs and barcodes in this field, you may have to first test that the initial character is a semicolon and you may have to first count the number of characters for the field if they are of variable length. The LEN function will do this.
    HTH

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: taking out a character (Access2000 SR1a)

    Another option where the semi colon is at the front would be as follows:
    Right([YourField],Len([Yourfield])-1)
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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