Suppress printing

Wim Ardon

Hi all!

I would like to suppress printing of a label in case the corresponding value is empty. I've added some code to the Render/Visible label like this:
Document("U_BASKLA") <> " " AND Document("U_BASKLA") <> Null

The first condition works fine, but if U_BASKLA IS NULL, suppressing print is not done.

What is the correct syntaxis of checking whether or not a value is NULL?

Thanks
Wim

Philipp Knecht

Hi Wim

If you use Data from Databand like you do it's enough to check for null like:
[quote]Document("U_BASKLA") <> ""

-->Databand("...") Gives back an empty string ("") for Null automatically (Adjustable with the emptyText POroperty on Databand)

If the value is numeric then null will be given back as 0

But if you would like to check explicitly for DBNull you can Use DataBand.IsEmpty("...")

hth

Wim Ardon

Hello Philipp!

The problem is solved! Thanks!

Gruss,
Wim