How To Hide Fields Without A Value On Report or List Layout
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.