convert empty label caption into number

[johncassell]

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

[Andy Pope]

Test the contents of the active cell and do appropriate code on result.

Please Login or Register  to view this content.

[johncassell]

Hi Andy, thanks for the reply. That is what I was doing but found a neater way now

val(label.caption) * 2

this will multiply the caption value by 2 even if the caption is empty.

John