Access 2000 - export Report design, not data

[Matt.]

Hi All!

Is it possible to export an Access Report? Not the report that is produced
when the report is run, but the actual framework, or source, of the report.
I'm trying to debug a report I didn't create, and in one field in the
GroupFooter, the Control Source property references another field, but I
cannot find the field referenced in the GroupFooter section, nor is it part
of the underlying query of the report, nor is there any VBA code associated
with the report that caould generate the field. I'd like to get the report
into some kind of text form, so that I could search. If there's another way
to solve this problem, I'd be happy to hear it.

Thanks in Advance,

Cheers,
Matt.

[feck]

On Mon, 6 Oct 2003 14:35:30 -0400, "Matt."
<ma*******************@hotmail.com> wrote:

Hi All!

Is it possible to export an Access Report? Not the report that is produced
when the report is run, but the actual framework, or source, of the report.
I'm trying to debug a report I didn't create, and in one field in the
GroupFooter, the Control Source property references another field, but I
cannot find the field referenced in the GroupFooter section, nor is it part
of the underlying query of the report, nor is there any VBA code associated
with the report that caould generate the field. I'd like to get the report
into some kind of text form, so that I could search. If there's another way
to solve this problem, I'd be happy to hear it.

Thanks in Advance,

Cheers,
Matt.

The missing field/Control Source could be a textbox etc. from a form
that is open to run the report, like a combobox for customer name, or
a start date and end date froming criteria for the underlying query ?
Check the rest of the forms for fieldnames.. just a suggestion

f

[Matt.]

Thanks Feck,

Unfortunately, the report is run directly from the Reports menu. It is not
called from a form, and no dialogue boxes are raised except for the one's
generated by the Report's Source (which do not affect the Footer).

I appreciate the quick reply though.

cheers,
Matt.

"feck" <ne*****************@hotmail.com> wrote in message
news:2g********************************@4ax.com...

On Mon, 6 Oct 2003 14:35:30 -0400, "Matt."
<ma*******************@hotmail.com> wrote:

Hi All!

Is it possible to export an Access Report? Not the report that is producedwhen the report is run, but the actual framework, or source, of the report.I'm trying to debug a report I didn't create, and in one field in the
GroupFooter, the Control Source property references another field, but I
cannot find the field referenced in the GroupFooter section, nor is it partof the underlying query of the report, nor is there any VBA code associatedwith the report that caould generate the field. I'd like to get the reportinto some kind of text form, so that I could search. If there's another wayto solve this problem, I'd be happy to hear it.

Thanks in Advance,

Cheers,
Matt.

The missing field/Control Source could be a textbox etc. from a form
that is open to run the report, like a combobox for customer name, or
a start date and end date froming criteria for the underlying query ?
Check the rest of the forms for fieldnames.. just a suggestion

f