I have a report that prints daily. The report needs to print whether or
not there are records available. I read in an old post on this group
that putting an unbound text box in the report footer, with the
following code in the OnNoData event would work like a charm --
Private Sub Report_NoData(Cancel As Integer)
Dim NoInboundLoads As TextBox
Me!NoInboundLoads = "No inbound loads scheduled for today."
Cancel = False
End Sub
However, I can't figure out why, but this text prints even when there
IS data available, as well as when there is not. I didn't think the
OnNoData event fired if there was data for the report?
I tried making the unbound control Not Visible by default, and adding
this line to the above code just after the Dim statement:
Me!NoInboundLoads.Properties Visible = True
But, I get an error message saying this is not supported.
How can I accomplish this?
Thanks,
Carla