no data property not working

[mrathi]

Hi,
I have a report and I have set the on no data property for it. All I say is on no data, cancel = true. In some of my reports out of the 10 to 15 different fields, I do have data only in 1 or 2 fields. In those cases, I want the report to print, however, it does not.

Any halp would be appreciated.

Thanks

 

[dhookom]

If there are any records in the report, the NoData event will not be executed. This event doesn't look at field values, only the number of records returned.

Duane
MS Access MVP