No records found!

[richmond]

Hi There,__I want a report that when no data matches the filter prints a page with the text "There were no records found." instead of popping up the dialog box "No records found."____Can this be done?____Thanks in advance,__Dean__

[kfleming]

It can only be done with runtime not the report designer.__You can add a title band to your report with the text No records found. Then create a calculated field with the expression RECNO()>1__Use this calculated field as the logical field to control the title band and select print when false.__When you run the report using runtime and no records are found, this conditional band line will then print the text No records found.____Kathleen__R&R Support

[richmond]

Thank you! Will this work if the report is run via the OCX as well?____Many thanks,__Dean__