Hi All

I have an address label that will not remove the address lines when empty. I have the "remove when empty" box checked. The value is null when empty so I tried adding nvl(line1,''), nvl(line1,space(0)) and that did not help. Any ideas of what I am doing wrong?

Thanks.