Empty Data Source problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
In a report we have a bool column which is bound to a textbox. The value
in textbox depends upon whether [ColumnBool] is True or False.
Following the condition kept in Control Source :
=IIf([ColumnBool]=True,"a","")
But the problem is coming when database does not return any data. In this
case #Error is coming in report. Our requirement is that we display "" when
no data is returned to report.

Thanks,
Abhi
 
You must log in or register to reply here.

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

Similar Threads

Subreport and Header Empty 1
Using Reports with multiple sources 2
Formating the output of report's TextBox 6
formatting textboxes from VBA to display those with data 6
# Error when no data 4
Dynamic adding of columns in Report 2
No Data return 0 instead of #error# 6
conditional control source property 4

Back
Top