Text box text manipulation

[Chris]

I have text box where the user enters a 3 digit number I would like to take
the 1st number and sepearte it from the last 2 numbers, so that i can use
them for different parts of my where clause in the query i am running

[Colin McGuigan]

Chris wrote in message <38e3898f$1@news.devx.com>...
>
>I have text box where the user enters a 3 digit number I would like to take
>the 1st number and sepearte it from the last 2 numbers, so that i can use
>them for different parts of my where clause in the query i am running

Check out the Mid() function:

First number: Mid(txtText.Text, 1, 1)
Second and third numbers: Mid(txtText.Text, 2, 2)

--
Colin McGuigan

[Joe Bissey]

"Chris" <c_unique@msn.com> wrote:
>
>I have text box where the user enters a 3 digit number I would like to take
>the 1st number and sepearte it from the last 2 numbers, so that i can use
>them for different parts of my where clause in the query i am running

Chris,

You could try using a mid$ function.I would also assign variables to the
values being passed to the query. for instance

Dim r,s as String
stext(this is the text box)

r=mid$(stext.text,1,1)
s=Mid$(stext.text,2,2)

You can then pass variables r and s to your query. I am using my sense of
logic and have not tried this out, but it should work.
If you try it and it works, let me know

Joe