I WANT headings to show when no data.

[Sharon]

I have six different subforms on my report. Each subform has a border around
it. If there is no data for the subform, I still want the headings and
border to show on the report. I know you are supposed to put a table
underneath the main table and use hide to had the table. Does anyone know
the code to do this?

 

[Gina Whipp]

Sharon,

Did you consider putting the heading outside but aboe the subreport? Then
they will sho because they are a part of the Main Report.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Duane Hookom]

I'm not sure why you referring to "subform" and "table" when I think you mean
"subreport" and "controls".

If a subreport doesn't return records, it will not render on the main
report. You can place controls on the main report behind the subreport. I
believe if the subreport doesn't render, you will see the controls. If the
subreport does contain data, it will hide the controls.

Another option is to use control sources of text boxes on the main report
like:
=IIf(sbrptCtrl.Report.HasData, Null, "My Label Caption")