access printer settings

[alritedonthaveacow]

hi
im using access 2003 and i want to know how to set a specific paper size
thanks

[ADezii]

hi
im using access 2003 and i want to know how to set a specific paper size
thanks

The following code will set the Paper Size setting for frmEmployees to Letter.[CODE=vb]DoCmd.OpenForm "frmEmploye es", acDesign, , , acFormEdit, acHidden

Forms!frmEmploy ees.Printer.Pap erSize = acPRPSLetter

DoCmd.Close acForm, "frmEmploye es", acSaveYes[/CODE]

Here is a listing of Paper Size Constants. You can reference their values in the Object Browser:
[CODE=text]
acPRPS10x14
acPRPS11x17
acPRPSA3
acPRPSA4
acPRPSA4Small
acPRPSA5
acPRPSB4
acPRPSB5
acPRPSCSheet
acPRPSDSheet
acPRPSEnv10
acPRPSEnv11
acPRPSEnv12
acPRPSEnv14
acPRPSEnv9
acPRPSEnvB4
acPRPSEnvB5
acPRPSEnvB6
acPRPSEnvC3
acPRPSEnvC4
acPRPSEnvC5
acPRPSEnvC6
acPRPSEnvC65
acPRPSEnvDL
acPRPSEnvItaly
acPRPSEnvMonarc h
acPRPSEnvPerson al
acPRPSESheet
acPRPSExecutive
acPRPSFanfoldLg lGerman
acPRPSFanfoldSt dGerman
acPRPSFanfoldUS
acPRPSFolio
acPRPSLedger
acPRPSLegal
acPRPSLetter
acPRPSLetterSma ll
acPRPSNote
acPRPSQuarto
acPRPSStatement
acPRPSTabloid
acPRPSUser [/CODE]

[abolos]

hi
im using access 2003 and i want to know how to set a specific paper size
thanks

If you are printing a report then right-click the report and select Page Setup. Then choose the paper size that you want.

Abolos