variable not capturing the "0" from user-entered info

[ratzy]

I'm querying an oracle ODBC database. the code is working fairly well, but my issues with that are in another thread. This thread is regarding the following:

step 1) Dim ProjectNo as Integer (I've used String to try to fix the problem, too)
step 2) user enters project number in text box on UserForm
step 3) ProjectNo=txtbox.value
step 4) Query uses "ProjectNo" to query the ODBC database.
step 5) Query returns values

My issue is this: If the project number starts with a "0," the variable does not capture that "0."

EXAMPLE:
User enters "0121" in text box and the query returns anything with a "121" in it. (e.g. 0121, 1121, 1215, etc)

So the data is convoluted and contains some correct info, but also some superfluous information as well.

Is there any way I can capture that zero in the variable?

[BigBas]

Did you try:

Please Login or Register  to view this content.

[ratzy]

Just tried it... still getting a variable value with no zero.
Thanks though!

[Norie]

I think we need to see your actual code.

[ratzy]

Oh but you just fixed the problem altogether, because now with:

Please Login or Register  to view this content.

I tried entering the full project number (it happens to include a letter in it, e.g. N0121) and it doesn't give me any sort of error like it was doing before with the text box declared as a "Value" not "Text."

That's better than fixing my original problem!

Thanks a ton

[BigBas]

I'm glad I could [indirectly] help.