# why this is happenning ?

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.
###### Who is Participating?

x

Commented:
Let's assume that STRDATA looks like this:

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!

0

Commented:
Yes, mcrider is right:

The first numeric parameter of the Mid command is the starting position. Your mistake is that you thought the second numeric parameter is the ending position. It's not - it's the number of characters you wish to return starting from the position specified in parameter 2.
0

Author Commented:
Thanks a lot .

0

Commented:
Thanks for the points! Glad I could help!