ACC: Problems Outputting Report with Datasheet Form as Subreport (180458)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q180458 Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
If a report contains a form as a subreport, and the form is in Datasheet
view, if you try to output the report to another file format such as text
(*.txt), Microsoft Excel (*.xls), or rich text format (*.rtf) you may see
the following unexpected behavior, depending on your version of Microsoft
Access.
In Microsoft Access 97
----------------------
You receive the message
Now outputting page <x> of
'<reportname>' to the
file '<outputfilepath>'
where <x> is incremented indefinitely until you click Cancel. An output
file is not created.
In Microsoft Access 7.0
-----------------------
You receive the message
The Save As command can't process any subforms contained in your
report.
Do you want to proceed anyway?
When you click Yes, you receive the message
Now outputting page <x> of
'<reportname>' to the
file '<outputfilepath>'
where <x> is incremented indefinitely until you click Cancel. An output
file is not created.
This behavior occurs regardless of the file format to which you output the
report.
RESOLUTION
To work around this behavior, use the Save As Report option to save the
form as a report before you output the report. To do so, follow these
steps:
- In the Database window, right-click the form, and then click Save As
Report on the menu that appears.
- In the Save Form As Report dialog box, type a name for the report, and
then click OK.
- Open the main report in Design view.
- Right-click the control that contains the datasheet form, and then click
Properties.
- Click the Data tab and change the source object from Form.<Formname> to
Report.<Reportname>, where <Formname> is the name of the datasheet form
and <Reportname> is the name of the report you saved in step 2.
Modification Type: | Major | Last Reviewed: | 11/4/2003 |
---|
Keywords: | kbprb KB180458 |
---|
|