If Substring(Textbox.Text,0,1) < "J" Then ' ERROR!!!

Eveready · #1 (**permalink**) 02-12-2009, 07:38 PM

An error ocurred on sub main.button1.click

Line number 12

If SubString(Textbox1.Text, 0,1) < "J" Then
Error description:
La cadana de entrada no tiene el formato correcto.
Continue?

PD: Only with equal (=) work fine

¿And if i am making a mistake, what is the way to do that comparison?

Cableguy · #2 (**permalink**) 02-12-2009, 08:08 PM

How do you what to evaluate a letter?
This is not a bug iut only a misscode..
To evealuate a letter you shouls only compare if it is equal to, or not..(=,<>)

Code:

If SubString(Textbox1.Text, 0,1) < "J" Then

here you are trying to find if the reulting letters is LESS(?) than "J"..
This cannot be evaluetes this way..

to evaluate this issue, you should first convert your SubString(Textbox1.Text, 0,1) to the ascii table value...and THEN, compare with the ASCII value of the letter"J"...

See the ASC keyword on the main help....

Eveready · #3 (**permalink**) 02-12-2009, 08:12 PM

Thank you very much for your respond to my post dear friend, and i will try to compare in that way.

Obrigado.

Erel · #4 (**permalink**) 02-13-2009, 09:14 AM

You can also use StrCompare to compare strings by their lexicographic order.