Changing Paper size in application

[CD Tom]

I have a report that can fix on letter size paper of on legal size depending on the number of columns that is printed on the report. I would like to change the paper size in the program depending on the number of columns printed. I've tried using the Application.Pri nter.Papersize = acRPSletter but it doesn't seem to change anything, is there another command that I need to do along with this?

Thanks
CD Tom

[mshmyob]

Check out this post and see if it helps.

http://bytes.com/topic/access/answers/794305-paper-bin

cheers,

I have a report that can fix on letter size paper of on legal size depending on the number of columns that is printed on the report. I would like to change the paper size in the program depending on the number of columns printed. I've tried using the Application.Pri nter.Papersize = acRPSletter but it doesn't seem to change anything, is there another command that I need to do along with this?

Thanks
CD Tom

[CD Tom]

That is exactly what I was looking for. Thanks

[mshmyob]

You're welcome.. Good luck with your project.

cheers,

That is exactly what I was looking for. Thanks