Can I create a report based on a form

T

Tom

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
 
J

John Spencer

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
 
W

Wahab

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Design: Copy Style from Input "Form" to Output "Report" 2
Select Report Fields based on filtered form 0
Change report layout 1
Problem with report design 6
Page Orientation 1
One Command button for different reports 2
Filtering subreports on main report 0
Create a report based on information from two forms 2

Top