I am developing an application in Access 2007 and wish to control various printer options from within VBA code. Specifically I want to control whether pages are printed first-to-last or last-to-first.

I am unable to find a suitable property within the the printer object and I'm not aware of any API I could use.

Can anybody please offer any suggestions as to how I may proceed.

Thanks, Tony.

Do you want the end user to be able to decide this at the time they print or do you want to change the default?

Maybe this link (http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccessdev/html/ODC_MicrosoftOfficeDeveloperForumControllingYourPr interinMicrosoftAccess.asp) will help.

Do you want the end user to be able to decide this at the time they print or do you want to change the default?

I just want to change the default to be appropriate for the current report.

Then how about this link (http://allenbrowne.com/AppPrintMgt.html)?