Report Header

  • Thread starter Thread starter BGL42
  • Start date Start date
B

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!
 
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!
Click to expand...


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.
 
Back
Top