like this im using the below statement.
Text1 = Trim(Mid(STRDATA, 1, 1))
Text2 = Trim(Mid(STRDATA, 2, 5))
Text3 = Trim(Mid(STRDATA, 8, 8))
the problem is on the third line, the data that should be shown on text box is only 1 digit but why it show ten digits even i ask it to appear 1 digits only
ie 8 to 8 leght, even if i put Text3 = Trim(Mid(STRDATA, 8 , 20)) it
will show the same thing which is not correct data. how to ask it to appear the space or data that as our request.
pls help me.
thanks.
STRDATA = "1234567890abcdefghij"
Then:
Text1 = Trim(Mid(STRDATA, 1, 1)) 'WILL RETURN "1"
Text2 = Trim(Mid(STRDATA, 2, 5)) 'WILL RETURN "23456"
Text3 = Trim(Mid(STRDATA, 8, 8)) 'WILL RETURN "890abcde"
If you want Text3 to contain 1 character starting at position 8, you need to do this instead:
Text3 = Trim(Mid(STRDATA, 8, 1)) 'WILL RETURN "8"
Hope this helps!
Cheers!