Adding print button in form query

[Pinoycoderz]

Hi I'm a newbie here and I hope someone can help me... I just want to add a print button in form_query. but everytime I print the header of the form will be printed also. I just want to print the result in search keyword.

Please see the attachment.

 

[Frothingslosh]

I would do the following:

Turn off form painting with Me.Painting = False
Hide the header with Me.FormHeader.Visible = False
Print the form
Restore the header with Me.FormHeader.Visible = True
Turn form painting back on with Me.Painting = True

 

[RuralGuy]

Create a report that does what you want rather than printing the Form which was not designed for printing.

 

[Frothingslosh]

You know, RG, every time I try to teach best practices instead of just answering the question asked, I wind up with a fight on my hands!

 

[RuralGuy]

Not with me I hope. I meant no disrespect Sir.

 

[Frothingslosh]

Nah, it's generally from the folks asking the question.

 

[RuralGuy]

I don't see it in this case. You just having a bad day?

 

[Frothingslosh]

I didn't say it happened here, I just said it's what usually happens when I try that.

 

[RuralGuy]

Got it. Happens to me as well and I simply quit assisting a recalcitrant poster.