DoCmd.printout

[SpentGeezer]

Greetings,

Has anyone ever used Docmd.printout to print a form? If so how do you get it to fit to 1 page? Are there properties to do this?

Spent

 

[boblarson]

Just an FYI -

Forms are not designed to be printed. Just because you CAN print from a form doesn't mean you should. Reports are meant for printing. So, if you want a print and you want to be able to set the format and keep it to a page, etc. you need to set up a report that looks like the form (you can take the form and do a SAVE AS and save it as a report and then you can go modify it to be better formatted) and then you call the report (limiting to a single record) when you want to print it.

You can limit to a single record by using code like:

DoCmd.OpenReport "ReportNameHere", acViewNormal, , "[IDFieldNameHere]=" & Me!IDFieldFromFormHere

 

[SpentGeezer]

This works well, however I have a pivot chart in the form as a subform.

Any changes made to a pivot chart in the form are not relayed to the pivot chart in the report. This makes the pivot chart useless...

Any other ideas? I don't want to have to write a heap of VBA to update the Pivot chart in the Report...