-
I have a form i have made to look like an invoice but I don't want to use frmForm.Printform because I don't want all the menus and buttons to print. How can I make the form print the way I have made it to look.
Also I have an Excel spreadsheet that I was using to print these invoices, could I transfer the forms info to the spreadsheet I already have so it will print looking the way it always did.
I don't know which way will be easier.
By the way the this app is an access database control if that helps.
Thanks,
still a beginner,
JO
-
How about just setting then to invisible while printing.
Code:
Private Sub Command1_Click()
Command1.Visible = False
mnuFile.Visible = False
'print
frmForm1.PrintForm
'reshow them
Command1.Visible = True
mnuFile.Visible = True
End Sub
Gl,
D!m
-
Why didn't I think of that!!!
Perfect - thanks,
JO
