Creating labels

P

Pete Provencher

Using 2000

I'm attempting to create mailing labels and if there isn't any data in one
of my fields it prints out #error. If the field is null I would like it to
go to the next field and place it in that position. Is this possible.

Thanks in advance

Pete Provencher
 
R

Rick B

What is in your fields? NEed more detail here. Typically, I would create
mailing labels like this...


Unbound Field = [FirstName] & " " & [LastName]
Bound field (can shrink) [Address1]
Bound field (can shrink) [Address2]
Unbound Field = [City] + ", " + [State] + [Zip]




Rick B
 
M

msnews.microsoft.com

Thanks your example worked. Appreciate your help.

Pete Provencher
Rick B said:
What is in your fields? NEed more detail here. Typically, I would create
mailing labels like this...


Unbound Field = [FirstName] & " " & [LastName]
Bound field (can shrink) [Address1]
Bound field (can shrink) [Address2]
Unbound Field = [City] + ", " + [State] + [Zip]




Rick B




Pete Provencher said:
Using 2000

I'm attempting to create mailing labels and if there isn't any data in
one
of my fields it prints out #error. If the field is null I would like it
to
go to the next field and place it in that position. Is this possible.

Thanks in advance

Pete Provencher
Click to expand...
Click to expand...
 
Top