Access 2003 Report - Printer Settings

[jre1229]

I currently have the following code

 
 Dim stDocName As String
    stDocName = "rptProduct"
    DoCmd.OpenReport stDocName, acNormal, , "[Autonumber] = " & Me.AutoNumber
    DoCmd.OpenReport stDocName, acNormal, , "[Autonumber] = " & Me.AutoNumber

The problem I am running in to is that the printer it is using, has the right settings in the control panel's printer settings but the wrong setting in Access. I want to be able to print without going to the preview and changing the settings every time. It's a label printer, and the length and width settings are wrong. I also have to click "Use Printer Setting" on the advanced setup tab in order for it to work correctly. Any ideas on how to code these settings?

[RuralGuy]

IIRC, each report in design view will remember its own setup settings. Have you set the settings in design view yet and saved the report?

[jre1229]

I can't remember if I tried that or not, I will try it though and let you know how that goes. I know I changed the settings after the report was generated but I am not sure if I did in design view.

[jre1229]

Ok, I opened the report in design view, when to File-Print, changed my settings and printed it. I closed the designer, opened the report in preview mode, went to File-Print and the settings were back to the original settings, which were wrong.

[jre1229]

Nevermind, I went into the page setup and changed the settings there, saved it and it saved the settings! Great! Thanks for the help RuralGuy!

[RuralGuy]

Outstanding! Thanks for posting back with your success and solution.