Textboxes

[Subs]

Hi All

I am trying to evaluate two textboxes

If TextBox3.Value > TextBox2.Value Then
......
.......
Else
........

End If

but I am getting strange results with the above code
Is their a better solution to this.

Regards

Subs

[K Dales]

It would help to see what the strange results are, but I have an educated
guess. Do the textboxes contain numbers you want to compare? Textbox values
are strings; an alpha comparison on strings gives different results than a
numeric comparison - to see what I mean try this in the immediate pane:
? "10" > "2"
Should show the answer is "False" - alphabetically, the "1" in "10" comes
before "2".
Do it this way:
If Val(Textbox3.Value) > Val(Textbox2.Value) Then ...
This converts the text to numeric values for the comparison
--
- K Dales


"Subs" wrote:

> Hi All
>
> I am trying to evaluate two textboxes
>
> If TextBox3.Value > TextBox2.Value Then
> ......
> .......
> Else
> ........
>
> End If
>
> but I am getting strange results with the above code
> Is their a better solution to this.
>
> Regards
>
> Subs
>
>
>

[xxpeter]

Hi,

In the same way of thinking you can also convert the results to a
certain type and compare then :

If CInt(Textbox3.Value) > CInt(Textbox2.Value) Then ...
This converts the text to Integer values for the comparison

Warning : it's also good to check those values BEFORE you make the
comparison.
You can make the check with IsNumeric

Peter