Can I create a report based on a form

I have a form in access 2007 that contains all the information laid out
exactly as I want my report to be laid out. Can I create a report based on
that form layout and could you please explain the steps.


Thanks

Hmmm. Access 2007?

I can't check on 2007 at this point, but in earlier versions you could
right-click on the form in the list and choose Save As... and in the
subsequent dialog, you could choose REPORT from the "As" drop down. This
would save the form layout as a report layout.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Tom wrote:
I have a form in access 2007 that contains all the information laid out
exactly as I want my report to be laid out. Can I create a report based on
that form layout and could you please explain the steps.


Thanks

if you want to print the form same like report then
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70

use this one, any controls on form want to hide before this code and after
printing again make same.

"John Spencer" wrote:

Hmmm. Access 2007?

I can't check on 2007 at this point, but in earlier versions you could
right-click on the form in the list and choose Save As... and in the
subsequent dialog, you could choose REPORT from the "As" drop down. This
would save the form layout as a report layout.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Tom wrote:
I have a form in access 2007 that contains all the information laid out
exactly as I want my report to be laid out. Can I create a report based on
that form layout and could you please explain the steps.


Thanks

.