Greater than doesn't work when comparing values from two textboxes

[torppo]

Hi all,

I have a tricky situation where for some reason greater than is not working when comparing values between two textboxes. For example, if I write value 9900 in to TxtMuoSaldo and then value 999 to TxtMuoMaara I don't get right outcome. Code below.

Please Login or Register  to view this content.

Could there be something wrong with Textbox settings???

Thank you already in advance,

Ville

[nathansav]

You are running the code on the change event, which will run for 9, 9, 0 and 0, put it on the exit then the code will run on the value entered.

[torppo]

Hi nathansav,

And thank you for your reply. However, it didn't remove the problem so do you have any other idea??

[torppo]

Are there any other solutions for this??

[romperstomper]

Textboxes contain text, not numbers, and 9900 comes before 999 in alphanumeric sequence. Use the Exit event and use CDbl or Val to convert:

Please Login or Register  to view this content.

[torppo]

Woohoo!!

Thank you romperstromper, that really did the trick!! Super!!

Cheers,
Ville