OT- label making

[Erika]

Hi. Sorry to post this OT question here but wasn't sure where to go.

I have a db in Access 97 and need to make a sheet of labels. Are there
templates for Access for label making or should I use Excel or Word?

Thanks!

 

[Erika]

Considering this is a Publisher newsgroup, I'll recommend Publisher.

I don't see how to import a database file and make labels in Publisher.

I did mark the question OT A lot of you people here use more than
one Microsoft application and I just thought somebody might know the
easiest way to import a database file from access to print a sheet of
labels. If there is a better forum for this question, please tell me.

 

[Erika]

I don't see how to import a database file and make labels in Publisher.

I did mark the question OT A lot of you people here use more than
one Microsoft application and I just thought somebody might know the
easiest way to import a database file from access to print a sheet of
labels. If there is a better forum for this question, please tell me.

Never mind! I just found the label wizard in Access. Sweet!

 

[Guest]

-----Original Message-----
Hi. Sorry to post this OT question here but wasn't sure where to go.

I have a db in Access 97 and need to make a sheet of labels. Are there
templates for Access for label making or should I use Excel or Word?

Thanks!

--

Hugs, Erika

.

ACCESS LABEL MAKING:

Create a label

Use this procedure to create a stand-alone label (a label
that isn't attached to another control). To create a label
that's attached to a control, just create the control.
Microsoft Access automatically attaches a label to the
control when you create it.

Open a form in Design view, a report in Design view, or a
data access page in Design view.


Click the Label tool in the toolbox.


On the form, report, or data access page, click where you
want to place the label, and then type the text for the
label.
Notes

If you want to display the text in a label on more than
one line on a form or report, you can resize the label
after you enter all the text, or you can press CTRL+ENTER
at the end of the first line of text to enter a carriage
return. If you insert a carriage return, Microsoft Access
automatically wraps subsequent lines as you type. To
manually insert a line break on a subsequent line, press
CTRL+ENTER again. The maximum width of the label is
determined by the length of the first line of text.


If you want to use an ampersand (&) in a label on a form
or report, you must type two ampersands. This is because
Microsoft Access uses the ampersand in a label or button
to define an access key.

(Info: Access Help)