how to modify labels

[Guest]

I have created a report called Labels. How can I modify it so that the name
is on one line, the company on the next and so on?

 

[Arvin Meyer [MVP]]

I have created a report called Labels. How can I modify it so that the
name
is on one line, the company on the next and so on?

The label wizard should do that for you. If you need to modify it, use the
wizard first, then move what you need to. It is so easy to do that if you
mess up, you've generally only lost 5 or 10 minutes and can easily do it
again.

 

[John W. Vinson]

I have created a report called Labels. How can I modify it so that the name
is on one line, the company on the next and so on?

Open the report in Design view, and move the textboxes where you want them.
Then close the report and save it.

Not knowing anything about the structure of the report or about the query upon
which it is based, it's hard to be very specific - if you want a clearer
answer, please feel free to ask a clearer question!

John W. Vinson [MVP]

 

[Guest]

=Trim([FIRST NAME] & [LAST NAME] & [GROUP NAME] & [ADDRESS] & [CITY] &
[STATE] & [ZIP])

The wizard put the above is in one text box. I assumed incorrectly that
this would be easy to change. Each isn't seperated out so that I can easily
move it. Do I cut and paste each item into a seperate text box?

 

[Guest]

Try this --
=Trim([FIRST NAME] & " " & [LAST NAME] & Chr(13) & Chr(10) & [GROUP NAME] &
Chr(13) & Chr(10) & [ADDRESS] & Chr(13) & Chr(10) & [CITY] & " " & [STATE] &
" " & [ZIP])

--
KARL DEWEY
Build a little - Test a little

=Trim([FIRST NAME] & [LAST NAME] & [GROUP NAME] & [ADDRESS] & [CITY] &
[STATE] & [ZIP])

The wizard put the above is in one text box. I assumed incorrectly that
this would be easy to change. Each isn't seperated out so that I can easily
move it. Do I cut and paste each item into a seperate text box?

Open the report in Design view, and move the textboxes where you want them.
Then close the report and save it.

Not knowing anything about the structure of the report or about the query upon
which it is based, it's hard to be very specific - if you want a clearer
answer, please feel free to ask a clearer question!

John W. Vinson [MVP]

 

[John W. Vinson]

=Trim([FIRST NAME] & [LAST NAME] & [GROUP NAME] & [ADDRESS] & [CITY] &
[STATE] & [ZIP])

The wizard put the above is in one text box. I assumed incorrectly that
this would be easy to change. Each isn't seperated out so that I can easily
move it. Do I cut and paste each item into a seperate text box?

Ouch. Did the wizard create that or did you? Since you don't have anything
between the fields, this would give addresses like

JimSmithPersonnel318 Wendell St.CambridgeMA

which would probably NOT be what you want.

I'd strongly suggest designing a Label report yourself, using more than one
textbox. For instance you could have one textbox (the name) with a control
source

=[First Name] & " " & [Last Name]

and another with a control source

=[Address] & " " & [City] & " " & [State] & " " & [Zip]

These textboxes can be aligned on the Report so they print where you want them
on the label.

John W. Vinson [MVP]

 

[Guest]

The wizard did that over and over again.

I'll design the box myself.

=Trim([FIRST NAME] & [LAST NAME] & [GROUP NAME] & [ADDRESS] & [CITY] &
[STATE] & [ZIP])

The wizard put the above is in one text box. I assumed incorrectly that
this would be easy to change. Each isn't seperated out so that I can easily
move it. Do I cut and paste each item into a seperate text box?

Ouch. Did the wizard create that or did you? Since you don't have anything
between the fields, this would give addresses like

JimSmithPersonnel318 Wendell St.CambridgeMA

which would probably NOT be what you want.

I'd strongly suggest designing a Label report yourself, using more than one
textbox. For instance you could have one textbox (the name) with a control
source

=[First Name] & " " & [Last Name]

and another with a control source

=[Address] & " " & [City] & " " & [State] & " " & [Zip]

These textboxes can be aligned on the Report so they print where you want them
on the label.

John W. Vinson [MVP]

 

[John W. Vinson]

The wizard did that over and over again.

My opinion of the skill level of the form wizards has never been all that
high... and it just went down a couple more notches. :-{(


John W. Vinson [MVP]