Prev: Data validation
Next: TransferSpreadheet: Importing a Specific Spreadsheet
From: Stewart Berman on 19 Jan 2010 22:51
I have some sub reports that have material in their headers that needs to be
displayed even if the sub reports do not contain any data.

If you open a report in print preview and it does not contain any data you
still see the report header information -- assuming that you did not use the
OnNoData even to cancel the report. However, if the same report is opened
in a sub report control it will not appear at all if there isn't any data.

Is there a way around this feature?
From: Allen Browne on 20 Jan 2010 04:36
The simplest way to do this is to more your column head labels out of the
subreport, and onto the main report.

--
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.


"Stewart Berman" <saberman(a)nospam.nospam> wrote in message
news:94vcl5lobc22lb40d0p7olven21maoooql(a)4ax.com...
> I have some sub reports that have material in their headers that needs to
> be
> displayed even if the sub reports do not contain any data.
>
> If you open a report in print preview and it does not contain any data you
> still see the report header information -- assuming that you did not use
> the
> OnNoData even to cancel the report. However, if the same report is opened
> in a sub report control it will not appear at all if there isn't any data.
>
> Is there a way around this feature?

 | 
Pages: 1
Prev: Data validation
Next: TransferSpreadheet: Importing a Specific Spreadsheet