Subreport Borders

[Melissa]

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

[Duane Hookom]

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