When report is empty show a standard phrase (newbie)

[bikemrh]

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?

 

[Allen Browne]

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.

 

[Rob]

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")

 

[bikemrh]

Allen,

This worked perfect. Thank you for your help.

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

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
would like to have a standard phrase show up such as "There are no
additons
today". I am using Access 2003.

Is this possible?