String Manipulation

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

Moved to Office Development forum

Hi ksushma, welcome to VBForums! :wave:

This can be acheived by using a little string manipulation, using functions such as Left and Len. You haven't mentioned if the number is a fixed length, if it is you could use something like this:

VB Code:

[I]OutputText[/I] = Left([I]InputText[/I],5) & "0"

However, if the length can vary you need to find the length too, using the Len function, eg:

VB Code:

[I]OutputText[/I] = Left([I]InputText[/I],Len([I]InputText[/I])) & "0"

Minor correction:

Code:

---

OutputText = Left(InputText,Len(InputText) -1) & "0"

---

Oops, well spotted!

Thank you very much it worked!!I will come back with more questions.