Print button

[Guest]

Hello
I want to put a button on the bottom of the form that sends the form to a
printer.

Is this possible?Thanks

Dave

 

[Guest]

Try

Docmd.PrintOut acSelection

 

[Guest]

Forms are really not for printing. You will usually be disappointed with the
results. it is better to create a report that contains the data on your form
and print the report. You can use the Where argument of the OpenReport
method to limit the recordset of the report to the current record on your
fomr.

 

[jahoobob via AccessMonster.com]

You can Save a form as a report to make it easy and then follow Klatuu's
suggestion.

Forms are really not for printing. You will usually be disappointed with the
results. it is better to create a report that contains the data on your form
and print the report. You can use the Where argument of the OpenReport
method to limit the recordset of the report to the current record on your
fomr.

Hello
I want to put a button on the bottom of the form that sends the form to a

[quoted text clipped - 3 lines]

Dave

 

[Guest]

Good point. Thanks for the info. Being a dedicated lazy person, I always
like finding ways to reduce work.

You can Save a form as a report to make it easy and then follow Klatuu's
suggestion.

Forms are really not for printing. You will usually be disappointed with the
results. it is better to create a report that contains the data on your form
and print the report. You can use the Where argument of the OpenReport
method to limit the recordset of the report to the current record on your
fomr.

Hello
I want to put a button on the bottom of the form that sends the form to a

[quoted text clipped - 3 lines]

Dave

 

[Guest]

Exactly what I wanted.

Thanks

Try

Docmd.PrintOut acSelection