Report Header

[BGL42]

How can I get an Unbound Object (parameter prompt) to
print in the Report Header when there is no data that is
output to the report? Example: Looking for items with code
730 and there are none. I want the 730 to show in the
report header to verify that I have checked for Code 730
and there was no output. It seems to only print if there
is data. Any help would be appreciated. Thanks!

 

[fredg]

How can I get an Unbound Object (parameter prompt) to
print in the Report Header when there is no data that is
output to the report? Example: Looking for items with code
730 and there are none. I want the 730 to show in the
report header to verify that I have checked for Code 730
and there was no output. It seems to only print if there
is data. Any help would be appreciated. Thanks!

Add a label to the report header.

Code the OnNoData event:

LabelName.Caption = "No data for " & [Exact Paramater Prompt]

Conversley, if you would like to save the paper and ink, code the
event:

MsgBox "No records for " & [Exact Paramater Prompt]
Cancel = True

You'll get a message, but the report wont print.