saving report as landscape orientation

[the_net_2.0]

Yet another problem with a report folks...

this thread suggests that changing orientation in preview mode and saving the report right then will preserve this setting:

http://forums.techguy.org/business-applications/688104-ms-access-changing-print-default.html

That does not work for me in 2007. It reverts right back to portrait when opened the next time.

Can someone help me on this little issue? I have tried the vba solution listed in the above thread. I will try that if all else fails.

thanks!

 

[SteveH2508]

There was a known bug in earlier versions of Access where Name-Autocorrect would mess up report orientation.Try turning it off if you have it enabled.

 

[the_net_2.0]

There was a known bug in earlier versions of Access where Name-Autocorrect would mess up report orientation.Try turning it off if you have it enabled.

and when I mess with the switch, should I try saving the report as I'm doing now? or try a different save method?

I did try all of the different combinations of this Steve, and it did not solve the problem. I do remember seeing threads about this bug as well. So I know this could be an issue. Using 07 here, but could not get that to return the correct result.

 

[vbaInet]

this thread suggests that changing orientation in preview mode and saving the report right then will preserve this setting:

It actually suggests changing it in design mode + saving it on close. Like you know, this is how permanent changes are made to form/report objects.

 

[the_net_2.0]

It actually suggests changing it in design mode + saving it on close. Like you know, this is how permanent changes are made to form/report objects.

of course I know that. and that doesn't work either, obviously.

This whole concept of how, where, when, and what to change in access objects is one of the main reasons why MS products completely suck. I've always disliked this "lack of feature" junk by MS. Too bad they really don't care about it more, as it is probably one of the main culprits of frustration between developers and customers.

 

[vbaInet]

The value for landscape is actually 2, i.e. acPRORLandscape and not 1. See if that works.

 

[the_net_2.0]

The value for landscape is actually 2, i.e. acPRORLandscape and not 1. See if that works.

in what argument? you're talking docmd.open rpt right?

 

[vbaInet]

In the .Orientation line. Try both:

Reports(strReportName).Orientation = [COLOR=Red]2[/COLOR]

Reports(strReportName).Orientation = [COLOR=Red]acPRORLandscape[/COLOR]

 

[the_net_2.0]

In the .Orientation line. Try both:

Reports(strReportName).Orientation = [COLOR=Red]2[/COLOR]

Reports(strReportName).Orientation = [COLOR=Red]acPRORLandscape[/COLOR]

I will give it a try, but my guess is that you can't change that prop unless it's in design mode. But I'll see. thanks. this will come after the docmd I'm using to open.

 

[vbaInet]

I will give it a try, but my guess is that you can't change that prop unless it's in design mode.

Yea, just like the code in the link specified. But, why are you looking to change it programatically anyway? You know that the layout of the controls will be messed up if you do?

 

[the_net_2.0]

Yea, just like the code in the link specified. But, why are you looking to change it programatically anyway? You know that the layout of the controls will be messed up if you do?

no idea. the way I have things now, it doesn't change. as in, I can open in preview, click the 'landscape' button and the only thing that changes is the scrollbar lengths, apparently because the width is getting more and the lentgh is getting less.

so if the code does that same thing, you would be wrong.

we'll see though, when I get to it.

 

[vbaInet]

no idea. the way I have things now, it doesn't change. as in, I can open in preview, click the 'landscape' button and the only thing that changes is the scrollbar lengths, apparently because the width is getting more and the lentgh is getting less.

It becomes more left aligned than justified though. As long as you're happy with that.

so if the code does that same thing, you would be wrong.

That's alright. I'm not perfect