+1 800 256 3608 (toll-free in North America) or +49 7531 90 60 10| service@combit.com

Condition with if formula

Hi there, I am new to List and Label and have probably a very simple question. I have a datafield what is not always being filled. Now I want put a condition into this line that it must show the data but when not filled then show a space.

I have tried this: if(V001 <> “”, V001, " ")
But when I preview the layout all lines are put up one line. When the field is filled in it works well. Can someone please help me. Thank you.

Dear Kees,
thank you for your note.

In this case you can try it with an non-breaking space e.g.

If(IsNullorEmpty(V001), Chr$(160), V001)

Kind regards

Erdal Alacali
Technical support
combit GmbH

© combit GmbH