On Open, Format Report

[foxhound]

Hello,

Does anyone know the code to automatically set the "On Open" code to make a report portrait, letter size, with .5" margins?

 

[foxhound]

Wow! Thought this would be an easy one.

 

[Corticus]

Hi foxhound,

Based on this:
http://www.theofficeexperts.com/forum/showthread.php?s=&threadid=1219&highlight=report

I would say you can't do it without lots of trouble. Unlike excel print methods, apprently Access's aren't nearly as accessable.

HTH,

 

[foxhound]

Corticus,

Thank you very much for your response. I have been searching everywhere to find code to make this happen. It's too bad that this can't be done because it would save me a lot of headaches!

 

[Philem]

Hullo. It actually can be done. You just cannot be at all worried about using some rather "raw" API calls to the Windows print system. I do something extemly similar with a report of mine that was designed on legal setup. It was annoying to switch the page layout whenever we needed to check something, so, I wanted it to preview/print automagically on legal. The following link http://ourworld.compuserve.com/homepages/attac-cg/acgsoft.htm helped rather a lot.

You'll need to set up a form with a report launch button, because as near as I can tell, this will only work if something CALLS the report, not if you preview/print the report directly.

If you have questions or problems, let us know.

HTH

P

 

[Corticus]

Nice Philem,

It was suggested in my link that I could use API to do what I wanted (and the OP wanted) but it was never actually provided. Thanks for providing a final solution to this.

I noticed that there was no way to set the number of columns property, unfortunately, which was what got me looking for a way to manipulate the page setup properties in the first place, but it looks like you got the OP in this thread well covered.

Thanks!