1 Reply Latest reply on Apr 15, 2013 11:12 AM by philmodjunk

    How To Hide Fields Without A Value On Report or List Layout

    VincentCapone

      Title

      How To Hide Fields Without A Value On Report or List Layout

      Post

           Hi,

           We have a database called "Jobsites". Each record has a seperate field for each subcontractor totalling 14 (ie; electrician, masonry, glazier, etc.).  Records have a status of  "Active" or "In-Active".  

           I'm trying to put in list format only showing the contractor fields that have a value of every  "Active" record, hiding the fields that are empty. This is for viewing and editing, and not printing. 

           Can this be done, or do all 14 fields have to be present with a huge blank space between the empty ones.  

           Thank you,

           Vinny

        • 1. Re: How To Hide Fields Without A Value On Report or List Layout
          philmodjunk
               

                    Each record has a seperate field for each subcontractor totalling 14 (ie; electrician, masonry, glazier, etc.).  Records have a status of  "Active" or "In-Active".

               Put each of those separate fields into different records in a related table linked to your current table. You can then set up a list view layout based on this new table and pull data in from the original table to be present in sub heads created from Sub Summary layout parts.