Print Button on Form.

[doders]

Hi... being extremely new to Access, i am sitting here frustrated as anything trying to make this work. I will attempt to explain what I am trying to do.

I have a form that has a combo box in it. This combo box references a table and pulls in the data depending on the company that is selected. What I am trying to do is add a print button on the form, so that the users can print off an address label. Now I can use the normal print report feature and this prints of the entire report, but what i would really like is the print button just to print the fields I want and not the whole thing. The fields I want to print are.

Name_1
Delievery_Address_1
Delievery_Address_2
Delievery_Address_3
Postcode

Ive had a look in the event field for the print button, but I have no idea of the commands to make it only select the fields that I want to print.

I truly am lost, and seeking guidance from the masters here at Access World.

My printing problem is in your hands.... cheers Paull

 

[trucktime]

Print

You can use the label wizard to create the desired output, this way you can select label size and the fields you want to print.

The command button should enable you to print a label for the current record.

Please search the forum, there are plenty of posts on this topic.

 

[doders]

OK.. got the label thing sorted. However, when assigning the task to the command icon, i dont have a choice to print current record to the label that i created. These are the choices that I get.

Record Operations - Print Record (no choice of label)
Form Operations - Print Current Form, No label choice here
Form Operations - Print Form, again no label choice.
Report Operations - Print Report, My label is a choice here, but it prints everything from the query and not the current record.

I really am lost...

 

[trucktime]

Print

You have to identify the record you need to print the label for.
Check this link:

http://www.mvps.org/access/reports/rpt0002.htm