473,474 Members | 1,353 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

I want to print a form in paper size width 11.5" and Length 8". How can I Page setup?

1 New Member
Here is my coding..


Expand|Select|Wrap|Line Numbers
  1.  cmdPrint.Visible = False
  2.  cmdMoveFirst.Visible = False
  3.  cmdMoveNext.Visible = False
  4. cmdMoveLast.Visible = False
  5.  cmdMovePrevious.Visible = False
  6.  cmdFind.Visible = False
  7.  Label6.Visible = False
  8.  txtCriteria.Visible = False
  9.  cmdGo.Visible = False
  10. cmdCancelFind.Visible = False
  11. cmdBack.Visible = False
  12. cmdGoTo.Visible = False
  13. cmdExit.Visible = False
  14. cmdNewRecord.Visible = False
  15. cmdSaveRecord.Visible = False
  16. cmdCancelNew.Visible = False
  17. cmdDeleteRecord.Visible = False
  18. cmdUndo.Visible = False
  19.  
  20. 'center the form:
  21. Me.Top = (Screen.Height - Me.Height) / 10
  22. Me.Left = (Screen.Width - Me.Width) / 280
  23.  
  24. 'display date & time
  25. lblDate.Caption = Format$(Date, "d/m/yyyy")
  26. lbltime.Caption = Format$(Time, "h:nn AM/PM")
  27.  
  28. Printer.PrintQuality = vbPRPQDraft
  29.  
  30. 'printer.height=7920
  31. 'printer.width=12240
  32.  
  33. Printer.FontSize = 10
  34. Printer.CurrentX = 28000
  35. Printer.CurrentY = 1500
  36.  
  37.  
  38.  
  39.  
  40. CustDetails.PrintForm
  41.  
  42.  
  43.  
  44.  cmdPrint.Visible = True
  45.  cmdMoveFirst.Visible = True
  46.  cmdMoveNext.Visible = True
  47.   cmdMoveLast.Visible = True
  48.  cmdMovePrevious.Visible = True
  49.  cmdFind.Visible = True
  50.  Label6.Visible = True
  51.  txtCriteria.Visible = True
  52.  cmdGo.Visible = True
  53. cmdCancelFind.Visible = True
  54. cmdBack.Visible = True
  55. cmdGoTo.Visible = True
  56. cmdExit.Visible = True
  57. cmdNewRecord.Visible = True
  58. cmdSaveRecord.Visible = True
  59. cmdCancelNew.Visible = True
  60. cmdDeleteRecord.Visible = True
  61. cmdUndo.Visible = True
  62.  
  63. End Sub
May 23 '15 #1
0 1126

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

Similar topics

0
by: Todd | last post by:
I have a mix of reports that are designed to print on either legal or letter size paper. When a legal sized report is first viewed in Print Preview, Page Setup uses the default Window printer's...
5
by: Ira S | last post by:
I use a DYMO labelwriter with my Access 97 database. I just purchased a new computer and in the report section under page setup/paper size, the new computer keeps changing the size automatically. I...
5
by: bcanavan | last post by:
When I export xml(and xls) from Access 2003 the result is a complete report in a single page. I would like to get the entire report in a single page (one trip to the server) for printing and...
1
by: Andrew | last post by:
I'm adding this as it to me a while to figure out all the pieces to be able to do this without using Microsoft.Office.Interop which caused me problems on the web-server. Streaming is the easy...
3
by: D Witherspoon | last post by:
No matter what I do the default paper size is always either A3 or 11 by 8.5 .. Here is the code. Dim dlg As DialogResult pd.DocumentName = "Weld Image" Dim pkPaperSize As New...
0
by: Nickneem | last post by:
I'm having a hard time trying to print a crystal report on a 1400 x 2970 (mm) custom form. I created a new form (start - settings - printers - server properties - create new form) 14 x 29,7 cm. In...
6
by: Brewtzaff | last post by:
Hello, I have a little problem to print my reports on custom sized paper. I got a db containing clubmembers, a query which selects only the needed infos to print out my membershipcards. My...
5
by: Simon Benson | last post by:
Probably a fairly simple problem but one that's been plaguing me for a couple of days... can anyone help? I have a classic ASP page with a number of text boxes which are updatable. For...
4
by: ARC | last post by:
I have reports that are designed to where it doesn't matter if the region using the program uses a letter sized paper or A4 sized. I have the width to be just slightly over 7", so the reports work...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.