change text after scanning to remove first 2 characters from scan (1 Viewer)

[hullstorage]

Hi all, we use a scanner to scan part barcodes when booking in to stock

example of part number on label
PWR-C5-600WAC=
actual scan inputs in field as
1PPWR-C5-600WAC=

so as you can see it add 1P which is what we need to remove

same as serial
ART2509D1S9

actual scan
SART2509D1S9

so need to remove the S

sometime the barcode will be damaged so need to take in to account the user will only input what they see from the label which does not show the 1P and the S

Cheers

 

[Gasman]

So check if the first two characters are 1P, (or first character is an S) and if they are use Right() or Mid() to get rid of them?

 

[hullstorage]

is this after update event and can you give example please - field name is PartNo and SerialNo

 

[Gasman]

Yes, AfterUpdate event of the control would be the place I would add my code.
Just look up those functions, plenty of examples already out there. You would also need the Len() function.

 

[Pat Hartman]

What is causing the extra characters?
What is the pattern of extra characters?
How do you know how many characters to remove?

 

[The_Doc_Man]

I've been out for a walk so missed this question earlier, but Pat has hit the target squarely... as she usually does.

If there is a pattern to the removal, we need to know what it might be. But of greater importance is how Access will be able to know what actually happened during the scan. Your characters to be removed don't follow a clear pattern and the characters to be retained don't follow a clear pattern either. I am going to have to say that without more information, I believe you cannot do this by simple programming. I will add more to Pat's list...

How do you know how many characters to keep?
How can you decide that a barcode was damaged?

And I will point out that if YOU can't answer these questions, neither can Access. And neither can we.

Understand this: Access is dumber than a box of rocks when it comes to the real world. All Access knows how to do is make tables, queries, forms, reports, macros, and modules. It is up to you to provide any other knowledge needed for the operation.