Student1000
05-27-2010, 03:33 AM
I would like to print a userform that displays all the important results.
Currently I am using this code:
Private Sub CommandButton2_Click()
Me.PrintForm
End Sub
However, my userform is too large to fit on a A4 paper. can I somehow open the printer menue before the print starts? so that i can enter "fit to paper size"?
Furthermore, I have a listbox on my userform showing the top 3 results. by clicking on each of them the respective information are displayed on the userform. As a result, If i press print, it does not print only the active page, but all of the pages that correspond to the top 3 search results. How can I make sure that only the current active page is printed?
thanks for any help.
cheers
Currently I am using this code:
Private Sub CommandButton2_Click()
Me.PrintForm
End Sub
However, my userform is too large to fit on a A4 paper. can I somehow open the printer menue before the print starts? so that i can enter "fit to paper size"?
Furthermore, I have a listbox on my userform showing the top 3 results. by clicking on each of them the respective information are displayed on the userform. As a result, If i press print, it does not print only the active page, but all of the pages that correspond to the top 3 search results. How can I make sure that only the current active page is printed?
thanks for any help.
cheers