468,505 Members | 1,570 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,505 developers. It's quick & easy.

Subreport Borders

A form in my database has multiple subforms. If any subform has no data, the
borders of the subform still display on screen and also are printed if I
print the main form. Reports are different. If a subreport has no data, the
borders of the subreport do not appear in Print View nor do they print with
the report. I need the borders to print whether the subreport has data or
not. Is there any way to get the subreport borders to print when a subreport
has no data?

Thanks!

Melissa


Nov 13 '05 #1
1 2316
You could add a rectangle control around the subreport (recAroundSub) and
then use code in the on Format event of the section containing the subreport
Me.recAroundSub.Visible = Not Me.srptMySub.Report.HasData

--
Duane Hookom
MS Access MVP
--

"Melissa" <mr******@earthlink.net> wrote in message
news:GT***************@newsread3.news.atl.earthlin k.net...
A form in my database has multiple subforms. If any subform has no data,
the
borders of the subform still display on screen and also are printed if I
print the main form. Reports are different. If a subreport has no data,
the
borders of the subreport do not appear in Print View nor do they print
with
the report. I need the borders to print whether the subreport has data or
not. Is there any way to get the subreport borders to print when a
subreport
has no data?

Thanks!

Melissa

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Ellen Manning | last post: by
reply views Thread by Melissa | last post: by
1 post views Thread by Melissa | last post: by
1 post views Thread by shaqattack1992-newsgroups | last post: by
3 posts views Thread by gieforce | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.