Tough Report Questions!!

[raymond3090]

ok everybody, a couple of tough ones (at least I think they're tough!!)

Hi, I have a form where a user can select from combo boxes and multi-select list boxes the data types and parameters they want to appear on a report.

When my code finishes, the report is shown in print preview. I know I will always want the report to be landscape oriented, but I have to go in and manually change that everytime now. How can I automate this?

In addition, I often have many columns of data going across the page, and even if in lanscape, I can't fit them all on one page when printed. As a result, some controls get cut between two pages. Is there any way to avoid this? For example, can I somehow say if the whole control can't fit on this page, then place it at the start of the next?

Regards,

-Ray

 

[Matt Brown]

I think i can answer your first question:

In the reports design view go to page setup and select either landscape or portrait.
Ok that and click save.

This will set the page orientation to whatever you selected as a default to the report.

Works for me.

Your second question i would imagine there is some code that would do what you are after but i dont have it right now.

 

[raymond3090]

thanks matt! That works just fine!!

Still stumped on the second one though. Any takers?

-ray

 

[Pat Hartman]

The answer to the first question is actually that it is an Access bug. Go to Tools/Options/General and uncheck all the options under Name AutoCorrect. Leave these options off unless you are going to make database changes that you want Access to track for you. Once the changes are made, turn the options off again. As long as they are set, Access will continue to loose margin settings.

As to the second problem, I'm not sure that I understand what you are asking. Don't you preview your reports after you build them to see how they look? If a control is split, open the report in design view and adjust the margin or spacing until the problem is resolved.