Printing Labels from a form?

[MFulton via AccessMonster.com]

Greetings,

Goal: I just want a form where the user can type in what needs to be printed
on a label and click the print button to print it. For example: If the user
needs to print a label that says: Monday, they type monday into a text box
and click print and the label prints. Any ideas, I don't need the any of the
information they are typing in saved, just need the user to be able to print
custom labels when needed. Thanks in advance for your responses, they are
appreciated

 

[Tom van Stiphout]

On Tue, 17 Nov 2009 12:47:08 GMT, "MFulton via AccessMonster.com"

Say you have a form named myForm with a textbox named myTextbox.
Create an unbound blank report, put a textbox on it, and set the
controlsource to:
=Forms!myForm!myTextbox

-Tom.
Microsoft Access MVP

 

[Mr. B]

To add to what Tom has said;

If you just wanted to print the info typed into the text box on a sheet of
paper then what Tom suggested will do that just fine.

However, if you are wanting to print to a sheet of labels, you will first
have to define your report to fit you sheet of labels. Also need some method
that will allow the user to specify then exact label on the sheet of labels
where the current information is to be printed.

Create your report and verify that it will print correctly on each and every
label.

As for allowing the user to specify the label where the info is to be
printed, I use a special form that I created that presents the user with a
replica of the sheet of labels. The user can then just click on the label
where the printing is to occur and the report will take the information
passed from the form to the report and print the data on the desired label.

It will take some programming, but it can be done.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[Thomas Kroljic]

Following up on what Mr. B wrote, if you do a Google search for the logic
(vba) that would allow the user to select the appropriate label to print on,
you'll find something you can immediately use. You might want to try this
website: http://www.granite.ab.ca/accsmstr.htm they might have what you
need.