(Msg. 1) Posted: Thu Jul 24, 2008 9:43 am
Post subject: If subreport has no data return "None" Add to elertz Archived from groups: microsoft>public>access>reports (more info?)
Is it possible to somehow code a subreport to return the value "None" in a
Label if the tables in a subreport are blank?
I have a subreport called Security. If no data is entered I would like the
report to just show "None" or "N/A" or something like that.
(Msg. 2) Posted: Fri Jul 25, 2008 1:22 am
Post subject: Re: If subreport has no data return "None" Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Test the HasData property of the report in the subreport control.
Place a text box on the main report in the same section as the subreport.
Set its Control Source to an expression such as this:
=IIf([Security].[Report].[HasData], Null, "None")
--
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.
"Ben" <Ben RemoveThis @discussions.microsoft.com> wrote in message
news:BE970137-2057-4380-BDA7-A986C5B4D687@microsoft.com...
> Is it possible to somehow code a subreport to return the value "None" in a
> Label if the tables in a subreport are blank?
>
> I have a subreport called Security. If no data is entered I would like
> the
> report to just show "None" or "N/A" or something like that.
>
> Make sense?
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office Other