By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,985 Members | 1,885 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,985 IT Pros & Developers. It's quick & easy.

Help with Access Reports

P: n/a
Iíve just recently started working with Access at my new job. Iíve been
able to figure out quite a bit on my own, but Iím stuck with a problem I
canít seem to find answer to on the Access help or website Ė nor the
ďAccess BibleĒ Iíve been using as a reference guide.

My question is Ė Iíve created a large report with several subreports on
the main report. The information is all linked but my problem comes
when I preview the report, if there is no information in a linked
record, the subreport doesnít appear at all. It seems they only appear
when information has been added to the corresponding form. Is there a
way to view the reports even if there is currently no information in the
table/form?

*** Sent via Developersdex http://www.developersdex.com ***
Feb 9 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Susan-MN wrote:
>Iíve just recently started working with Access at my new job. Iíve been
able to figure out quite a bit on my own, but Iím stuck with a problem I
canít seem to find answer to on the Access help or website Ė nor the
ďAccess BibleĒ Iíve been using as a reference guide.

My question is Ė Iíve created a large report with several subreports on
the main report. The information is all linked but my problem comes
when I preview the report, if there is no information in a linked
record, the subreport doesnít appear at all. It seems they only appear
when information has been added to the corresponding form. Is there a
way to view the reports even if there is currently no information in the
table/form?

No. However it's easy to display something else when the
subreport has no data. For example, you can place an
invisible label (caption of "No Data for ...") on top of the
subreport control. Then use a line of code in the Format
event procedure of the section containing the subreport
control:
Me.thelabel.Visible = Not Me.subreport.Report.HasData

--
Marsh
Feb 9 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.