Hello!
I am trying to make certain fields on a report visible or invisible based on values in another field.
I have a field [Status_SchoolStatus] that is a lookup field with two options: "Currently Active" or "Closed"
I have one field, [Year of Closing], I would like to hide if [Status_SchoolStatus] = "Currently Active"
I have two fields, [School Website] and [School Phone Number] I would like to hide if [Status_SchoolStatus] = "Closed"
I have managed to make this work fine by conditionally formatting the text boxes to appear with white text (same colour as the background), using Expression Is [Status_SchoolStatus] = "Closed" and [Status_SchoolStatus] = "Currently Active" and setting the appropriate font colour for each.
However, this does not affect the labels. Is it possible to format the labels as well?
I've searched through a few forums and a common answer was to change the labels to text boxes, but that opens up a whole can of worms regarding control sources, and I can't get the labels that I turn into text boxes display the desired text, they'll either display the text in the associated text box or bring up a parameter input dialogue when I try to run the report.
I would like the labels for each of these fields to display "School Website", "School Phone Number" and "Closing date", respectively.