Hello,
I have a report that shows dollars earned for each month of the year. It is based on a crosstab query. The report shows not only fields with dollar amounts in them, but also blank fields, because each field has a border. I would like to show only those fields that are not null.
I have done the following: Set the visible property on each month field to no, and wrote the following code for the "on open" property of the report:.
If IsNull (Me.SumOfFeb) Then
Me.SumOfFeb.visible= False
Else
Me.SumOfFeb.visible=True
End If
I wrote the above for each month in the report. When I run the report all the fields whether null or not become visible. If I remove the event procedure they all become invisible. Can someone tell me what I am doing wrong?
I have a report that shows dollars earned for each month of the year. It is based on a crosstab query. The report shows not only fields with dollar amounts in them, but also blank fields, because each field has a border. I would like to show only those fields that are not null.
I have done the following: Set the visible property on each month field to no, and wrote the following code for the "on open" property of the report:.
If IsNull (Me.SumOfFeb) Then
Me.SumOfFeb.visible= False
Else
Me.SumOfFeb.visible=True
End If
I wrote the above for each month in the report. When I run the report all the fields whether null or not become visible. If I remove the event procedure they all become invisible. Can someone tell me what I am doing wrong?
