Checking if value is negative

[MarmaladeLover]

Greetings,
In my form, I have textboxes which cannot have negative values - with than in mind, I have code such as

Please Login or Register  to view this content.

That works fine when the value is negative.
The issue is, there is an option to leave the box blank and it will calculate a default value based on previously entered parameters.
So, when the user leaves the box blank, it comes up with type mismatch when performing the above check.
I tried

Please Login or Register  to view this content.

Any suggestions?

[AlphaFrog]

Test if the textbox is not blank before trying to convert the text to a number. Maybe something like...

Please Login or Register  to view this content.

Additionally, this avoids a potential error if the user entered text instead of a number.

Please Login or Register  to view this content.

[MarmaladeLover]

I was just thinking that that would work. Just made some silly errors applying it with all the 019203910 surround ElseIf's I had going...
Thanks! It works.

[TMS]

Separate the tests. Check for blank first ... if it is, take the appropriate action. If it isn't, then check for the negative value.

Please Login or Register  to view this content.

Regards, TMS