Creating labels

  • Thread starter Thread starter Pete Provencher
  • Start date Start date
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
 
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
 
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...
 
Back
Top