Printing alternate text on report with no data

[Hers2keep]

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(C ancel As Integer)
Dim NoInboundLoads As TextBox
Me!NoInboundLoa ds = "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!NoInboundLoa ds.Properties Visible = True

But, I get an error message saying this is not supported.
How can I accomplish this?

Thanks,
Carla

[MGFoster]

Hers2keep wrote:

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(C ancel As Integer)
Dim NoInboundLoads As TextBox
Me!NoInboundLoa ds = "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!NoInboundLoa ds.Properties Visible = True

But, I get an error message saying this is not supported.
How can I accomplish this?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The correct syntax for setting the property is

Me!NoInboundLoa ds.Visible = True

Be sure the Visible property of the TextBox is set to False, otherwise,
it will always be visible.

For the message always showing:

Open the report in design view.
Open the Properties dialog box.
Click on the TextBox that holds the message.
Look at the ControlSource property (under the Properties dialog box's
Data tab).

I'll bet it has the message. If so, delete the message & save the
report. If not, I don't know what's going on.

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQjHiwIechKq OuFEgEQKlqgCgkK wZtsoctodTBfUxQ J02KQfTlBgAn1Ms
WL6kx90nmJxEkHd DJ135Cn62
=5KMZ
-----END PGP SIGNATURE-----

[Hers2keep]

Okay - now that part is all working on the individual reports. Here's
my next question.

There are two reports for each of the 6 locations - Inbound & Outbound.
Individually, they all work as they should. However, when I combine the
Inbound and Outbound for each location as two subreports in a main
report, the 2nd report doesn't print at all if it has no data.

End result needs to be one main report continaining a subreport for
each location, each location subreport containing the two subreports of
their inbound & outbound loads for a particular day.

Carla