I am using Visual Basic in Access for programming the Macros. I am using the access database to acquire data from lab instruments. I am using a bar code scanner and the output is as follows 103329. Now what I need to do is change it to 103320 (meaning I need to replace the last character with number 0). The last digit cud be any number and needs to be replaced with a 0. Please help