Printing a form

[joltremari]

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

[Dim]

How about just setting then to invisible while printing.

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

[joltremari]

Why didn't I think of that!!!

Perfect - thanks,

JO