Jump to content

Hiding empty fields and labels when printing


Nicnacs

This topic is 6461 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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 by Guest
Link to comment
Share on other sites

This topic is 6461 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.