Hiding empty fields and labels when printing

[Nicnacs]

Hello

I'm designing a database where I'd like to have some fields hiden on my print layout if they're empty. The fields in question will rarely have info in them. Is there a way of hiding them (or more specifically their labels) from a layout if the fields themselves are empty? I can't think of any little tricks to achieve this.

I thought they'd maybe be a script that would use the sliding/printing control but I can't find that option.

Any thoughts?

Thanks

[Stuart Taylor]

Create a calculation for the field to go on your print layout:

cPrint_Field_1 =

Case ( IsEmpty ( Field_1 ) ; "Label: " & Field_1 ; "" )

--

You could also have the label text in a global field say gLabel_Field_1

cPrint_Label_Field_1 =

Case ( IsEmpty ( Field_1 ) ; gLabel_Field_1 ; "" )

Edited September 16, 2006 by Guest