Converting a form to a report

[Tony Williams]

I have a rather complicated form, based on one table, that is made up of a
number of tabcontrols which all contain forms based on various tables.
Basically I want to create a report of all the controls on my form, whether
or not they contain data. Is there a quick way to convert my form to a
report or will I have to create the report by creating one main report and a
number of subreports, that will take hours!!!
Thanks
Tony

 

[krissco]

I have a rather complicated form, based on one table, that is made up of a
number of tabcontrols which all contain forms based on various tables.
Basically I want to create a report of all the controls on my form, whether
or not they contain data. Is there a quick way to convert my form to a
report or will I have to create the report by creating one main report and a
number of subreports, that will take hours!!!
Thanks
Tony

You won't like this answer, but I believe you are stuck with creating
your report the hard way.

-Kris

 

[Tony Williams]

UGH! I thought that was the case. I thought I'd seen a mention of a utility
that did this but maybe I'm mistaken.
Thanks anyway
Tony

 

[krissco]

UGH! I thought that was the case. I thought I'd seen a mention of a utility
that did this but maybe I'm mistaken.
Thanks anyway

Oh, it could be out there - I've just never heard of it.

-Kris

 

[John Spencer]

You can right-click on each form in the database window and SAVE it as a
report.
Then you can add each of the saved reports as sub-reports to a main report.

WARNING: THIS WILL GIVE YOU VERY UGLY REPORTS.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Tony Williams]

Thanks John didn't know that. Have tried and with a little bit of
experimenting it will give me what I want.
Tony