Adding a number to the first two characters of a string

nosaj03

Registered User.
Local time
Today, 10:42
Joined
May 29, 2016
Messages
21
I have a function that puts the first 2 characters of a string into a textbox. What Im attempting to do is add a "1" to those first two characters when an after update event occurs.

How would incorporate the "1" into the left(string,2) code to make it work?

Any help would be greatly appreciated.
 
do you want to append it at the end:

private counter as long

private sub form_afterupdate()
counter = counter + 1
me.textbox = Left(me.textbox,2) & counter
end sub
 

Users who are viewing this thread

Back
Top Bottom