I have this form that is too big to print on a page. Is there a way to fit a form onto a page without resizing the form itself?
Printable View
I have this form that is too big to print on a page. Is there a way to fit a form onto a page without resizing the form itself?
Try thisVB Code:
Option Explicit Private Declare Sub keybd_event Lib "User32" (ByVal bVk As Byte, _ ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long) Private Const VK_MENU As Byte = &H12 Private Const VK_SNAPSHOT As Byte = &H2C Private Const KEYEVENTF_KEYUP = &H2 Private Sub cmdPrintScreen_Click() Screen.MousePointer = vbHourglass Dim lWidth As Long, lHeight As Long Clipboard.Clear Call keybd_event(VK_MENU, 0, 0, 0) Call keybd_event(VK_SNAPSHOT, 0, 0, 0) DoEvents Call keybd_event(VK_SNAPSHOT, 0, KEYEVENTF_KEYUP, 0) Call keybd_event(VK_MENU, 0, KEYEVENTF_KEYUP, 0) Printer.Print If Width > Printer.ScaleWidth Then lWidth = Printer.ScaleWidth lHeight = (Printer.ScaleWidth / Width) * Height Else lWidth = Width lHeight = Height End If Printer.PaintPicture Clipboard.GetData, 0, 0, lWidth, lHeight Printer.EndDoc Screen.MousePointer = vbDefault End Sub