Text Boxes (Values) if blank equal to 0

[Gomquai]

Hello,

This is my first post, so I apologize if was posted in the wrong forum. Thank you in advance for reading and any assistance you provide to rectify the issue.

I have created a form with multiple (7) Text Boxes a user will enter data into. There is one Command Button that if clicked will perform multiple (3) calculations simultaneously and display the results of the calculation in a respective Label for that data. The problem is, some of the Text Boxes could be equal to "0". I would prefer a user to have the option of either entering "0" into the box or simply leave it blank. If left blank, clicking the Command Button would calculate as it should, but uses "0" for the blank fields. At the moment, if the fields are left blank, I receive an error.

Here is what I have so far, which works if I enter "0" into the text fields I would like to leave blank:

Please Login or Register  to view this content.

[Leith Ross]

Hello Gomquai,

Welcome to the Forum!

Replace the CDbl statements with Val. The Val statement will return a double value but will not error if it encounters a non numeric value in the text string.

[Gomquai]

You are a gentleman and a scholar, Sir! That works like a charm!

Excellent first experience! My hats off to you!

[Leith Ross]

Hello Gomquai ,

You're welcome. Thanks for joining our community.