Custom msg if is null

[teiben]

I need to issue a report (even if there are no records) so I can't use the OnNo Data method. I have a report with headings created I just need a textbox to display "There are no open issues". I've tried

IIf([Problem]="not null","No Open Issues")

Any idea'?

 

[KeithG]

you could make a new label on your report that Says No Open Issues and set its visible property to false. Then in the reports on open event use the dlookup function on the reports underlying query to check to see if there are records and if not make the label visible by setting the visible property to true.

 

[KeithG]

you could make a new label on your report that Says No Open Issues and set its visible property to false. Then in the reports on open event use the dlookup function on the reports underlying query to check to see if there are records and if not make the label visible by setting the visible property to true.