Report Header


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!
 
Ad

Advertisements

F

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top