September 16, 200619 yr 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
September 16, 200619 yr 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, 200619 yr by Guest
Create an account or sign in to comment