I have a subreport which consists of a text box which runs a query based on the main report and presents the data with labels. Here is an example of the expression:
="Alteration 1: " & [alt1] & " " & [alt1_int] & " " & [alt1_com] & " Alteration 2: " & [alt2] & " " & [alt2_int] & [alt2_com] & " Alteration 3: " & [alt3] & " " & [alt3_int] & " " & [alt3_com]
The record source is:
The problem I am having is that when there is no data it still shows the labels for the fields. Is there a way to set them to not visible if the record is null? I would prefer not to seperate each into different text boxes if at all possible.
Thanks,
Pam
="Alteration 1: " & [alt1] & " " & [alt1_int] & " " & [alt1_com] & " Alteration 2: " & [alt2] & " " & [alt2_int] & [alt2_com] & " Alteration 3: " & [alt3] & " " & [alt3_int] & " " & [alt3_com]
The record source is:
The problem I am having is that when there is no data it still shows the labels for the fields. Is there a way to set them to not visible if the record is null? I would prefer not to seperate each into different text boxes if at all possible.
Thanks,
Pam
