If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
OT- label making
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 |
#2
|
|||
|
|||
OT- label making
Considering this is a Publisher newsgroup, I'll recommend Publisher.
-- JoAnn Paules MVP Microsoft [Publisher] "Erika" wrote in 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.690 / Virus Database: 451 - Release Date: 5/22/2004 |
#3
|
|||
|
|||
OT- label making
JL Paules wrote:
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. -- Hugs, Erika |
#4
|
|||
|
|||
OT- label making
Erika wrote:
JL Paules wrote: 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. Never mind! I just found the label wizard in Access. Sweet! -- Hugs, Erika |
#5
|
|||
|
|||
OT- label making
-----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) |
Thread Tools | |
Display Modes | |
|
|