convert empty label caption into number

**johncassell** · 04-17-2009, 08:14 AM

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** · 04-17-2009, 08:20 AM

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

If Len(Activecell.Value) > 0 then
    if isnumeric(activecell.value) then
       ' do stuff
    else
       ' do stuff for non numeric content
    endif
Else
    ' do stuff for empty cell
End if

**johncassell** · 04-17-2009, 08:49 AM

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