When report is empty show a standard phrase (newbie)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bikemrh - 27 Sep 2007 17:13 GMT

I have a report with subreports in it. When one of the subreports is empty I
would like to have a standard phrase show up such as "There are no additons
today". I am using Access 2003.

Is this possible?

Reply to this Message

Allen Browne - 27 Sep 2007 17:33 GMT

Try a text box with this expression:
=IIf([Report].[HasData], Null, "There are no additions.")

If you have any other calculated fields, that might fail, since calculating
non-existent fields results in #Error, and Access quits calculating the
calculated controls when one is uncalculatable.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a report with subreports in it. When one of the subreports is empty
>I
[quoted text clipped - 3 lines]
>
> Is this possible?

Reply to this Message

bikemrh - 28 Sep 2007 14:21 GMT

Allen,

This worked perfect. Thank you for your help.

> Try a text box with this expression:
> =IIf([Report].[HasData], Null, "There are no additions.")
[quoted text clipped - 10 lines]
> >
> > Is this possible?

Reply to this Message

Rob - 27 Sep 2007 17:38 GMT

i would say:
create a field on your main report and give it the source
=IIf([subformname].[Report].[HasData];null;"The subform has no data")

> I have a report with subreports in it. When one of the subreports is empty I
> would like to have a standard phrase show up such as "There are no additons
> today". I am using Access 2003.
>
> Is this possible?

Reply to this Message