Hi,
I have this table with a field that accepts ID numbers. Unfortunately, the data is inputted from a barcode scanner which adds a ; to the beginning of the id numbers and a ? to the end of it. E.g. ;1234567?
Is there any way I could have Access filter out or remove those unwanted characters when the data is entered?
And could it be done without code because I'm kinda a new to Access.
Much thanks for any help
I have this table with a field that accepts ID numbers. Unfortunately, the data is inputted from a barcode scanner which adds a ; to the beginning of the id numbers and a ? to the end of it. E.g. ;1234567?
Is there any way I could have Access filter out or remove those unwanted characters when the data is entered?
And could it be done without code because I'm kinda a new to Access.
Much thanks for any help