Hi all,

could someone tell me if its possible to convert a blank string on a label into an integer?

My form loads and populates a label.caption with the value of the activecell.value.

Sometimes the activecell.value is empty and sometimes has a number in it.

I need to do a calculation (label.caption * 2) but if the label.caption is empty it throws an error. I need it to treat an empty label as zero.

Any help is greatly appreciated.

Thanks
John