JOHNHO
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks a lot .
Thanks for the points! Glad I could help!
Cheers!®©
Cheers!®©
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.