Nicnacs Posted September 16, 2006 Share Posted September 16, 2006 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 Link to comment Share on other sites More sharing options...
Stuart Taylor Posted September 16, 2006 Share Posted September 16, 2006 (edited) 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6559 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now