By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,234 Members | 1,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,234 IT Pros & Developers. It's quick & easy.

Problems printing forms/subforms

P: 10
I am currently building a database within Access 2007. I have a form that is populated via vba coding and thereform is not stored in a specific table.

I have created a button that essentially runs through all objects on the form and changes their formatting settings to that of an access report(Making the text blue etc). I did this because i have many different forms that i would like to able to print and thought this would be a quicker way rather than creating loads of reports/sub-reports.

I am however having a few problems printing the forms. When i go to print preview all the data is shown as it should. However when printed only data on the main form is printed. All the subforms are blank where data should be.

I have tried using different printers/ computers but i still have the same problem. Any help would be grateful please.

Cheers,

T
Jan 8 '08 #1
Share this Question
Share on Google+
1 Reply


P: 45
There is no benefit to printing Forms instead of Reports. Reports can be based on queries and recordsets just like Forms. Additionally reports can be created based on the input of a form. So there is no reason to have loads of reports either. Most of my databases have one or two reports - that output in hundreds of variations.

The drawback of using Forms as Reports is the page layout issues and the data control issues. Reports require the data to be static during assembly before printing. Forms do not.
Jan 11 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.