add 1 to the first 3 characters of a string

[jimmy1981]

Hi,

I have a barcode that once scanned returns a string 8 characters long.

Further along the program I have this line of code:

Mid(Header_FirstStop, 1, 3) = (Mid(Header_FirstStop, 1, 3) + 1)

Eg, 00100000 I would want to then be 00200000 or eg, 01200000 would be 01300000, yet when I add 1 it is not giving the desired result

Can somebody advise what I am doing wrong?

 

[jimmy1981]

it's ok, i sorted it, for anyone interested!

[SIZE=2]Mid(Header_FirstStop, 1, 3) = Format((Mid(Header_FirstStop, 1, 3) + 1), [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"000"[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2])
[/SIZE]