By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

access printer settings

P: 4
hi
im using access 2003 and i want to know how to set a specific paper size
thanks
Jul 20 '07 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,599
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.
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "frmEmployees", acDesign, , , acFormEdit, acHidden
  2.  
  3. Forms!frmEmployees.Printer.PaperSize = acPRPSLetter
  4.  
  5. DoCmd.Close acForm, "frmEmployees", acSaveYes
Here is a listing of Paper Size Constants. You can reference their values in the Object Browser:
Expand|Select|Wrap|Line Numbers
  1. acPRPS10x14 
  2. acPRPS11x17 
  3. acPRPSA3 
  4. acPRPSA4 
  5. acPRPSA4Small 
  6. acPRPSA5 
  7. acPRPSB4 
  8. acPRPSB5 
  9. acPRPSCSheet 
  10. acPRPSDSheet 
  11. acPRPSEnv10 
  12. acPRPSEnv11 
  13. acPRPSEnv12 
  14. acPRPSEnv14 
  15. acPRPSEnv9 
  16. acPRPSEnvB4 
  17. acPRPSEnvB5 
  18. acPRPSEnvB6 
  19. acPRPSEnvC3 
  20. acPRPSEnvC4 
  21. acPRPSEnvC5 
  22. acPRPSEnvC6 
  23. acPRPSEnvC65 
  24. acPRPSEnvDL 
  25. acPRPSEnvItaly 
  26. acPRPSEnvMonarch 
  27. acPRPSEnvPersonal 
  28. acPRPSESheet 
  29. acPRPSExecutive 
  30. acPRPSFanfoldLglGerman 
  31. acPRPSFanfoldStdGerman 
  32. acPRPSFanfoldUS 
  33. acPRPSFolio 
  34. acPRPSLedger 
  35. acPRPSLegal 
  36. acPRPSLetter 
  37. acPRPSLetterSmall 
  38. acPRPSNote 
  39. acPRPSQuarto 
  40. acPRPSStatement 
  41. acPRPSTabloid 
  42. acPRPSUser 
Jul 22 '07 #2

P: 65
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
Jul 23 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.