More Address labels


A

Asbjørn Søbye

I've created an address label report with four lines of text on each label.
Then I tried to put in a logo on the right side of the label (jpg or gif
format), but that ruined the whole report format. The line-spacing became
all wrong and the text didn't fit the labels anymore. What did I forget to
do?

Regards
Asbjørn Søbye
 
Ad

Advertisements

A

Asbjørn Søbye

No, I didn't, but after a little bit more "investigation" I've found out
what happens:
The function that removes empty lines from the report doesn't work when I
insert the picture (sorry, I don't know the correct name for this function
in english, but directly translated it's "Can shrink"). Does anyone know
why?

Regards
Asbjørn Søbye
 
D

Duane Hookom

Can shrink will not have any effect when there are controls directly to the
left or right of the "can shrink" control. If we knew your control
expressions we might be able to suggest a solution.
 
A

Asbjørn Søbye

I made a simpel query just so I could concatenate the first and lastname of
the persons name. I then made a label report with the wizzard. All
fieldnames in the report are like this: =Trim([Field1 to 6])
I have 6 fields in the report, one on each line and field 2 and 4 are empty
for most records.

Without the picture the empty lines are removed, when I insert the picture,
field (line) 2 and 4 are shown on each label even when they are empty.

I have not added any expressions manualy. The property sheet say "Yes" on
the "Can shrink" property for all fields. When I set this property to "No"
for all fields the report looks just like it does with the picture inserted.

I do not change the properties for the picture, they are all defaults.

Hope this help you to understand the problem.

Thanks for your help!!!

Asbjørn Søbye
 
D

Duane Hookom

You can try combine all your fields into a single text box:
=[Field1] & Chr(13) +Chr(10) + [Field2] & Chr(13) + Chr(10) +[Field3]...
Notice the use of "&" and "+" in this expression. If a field value is null,
the Chr(13) + Chr(10) will also be null.

--
Duane Hookom
MS Access MVP


Asbjørn Søbye said:
I made a simpel query just so I could concatenate the first and lastname of
the persons name. I then made a label report with the wizzard. All
fieldnames in the report are like this: =Trim([Field1 to 6])
I have 6 fields in the report, one on each line and field 2 and 4 are empty
for most records.

Without the picture the empty lines are removed, when I insert the picture,
field (line) 2 and 4 are shown on each label even when they are empty.

I have not added any expressions manualy. The property sheet say "Yes" on
the "Can shrink" property for all fields. When I set this property to "No"
for all fields the report looks just like it does with the picture inserted.

I do not change the properties for the picture, they are all defaults.

Hope this help you to understand the problem.

Thanks for your help!!!

Asbjørn Søbye

Duane Hookom said:
Can shrink will not have any effect when there are controls directly to the
left or right of the "can shrink" control. If we knew your control
expressions we might be able to suggest a solution.
when
 
Ad

Advertisements

A

Asbjørn Søbye

That made the trick!

Thanks!

Asbjørn Søbye

Duane Hookom said:
You can try combine all your fields into a single text box:
=[Field1] & Chr(13) +Chr(10) + [Field2] & Chr(13) + Chr(10) +[Field3]...
Notice the use of "&" and "+" in this expression. If a field value is null,
the Chr(13) + Chr(10) will also be null.

--
Duane Hookom
MS Access MVP


Asbjørn Søbye said:
I made a simpel query just so I could concatenate the first and
lastname
of
the persons name. I then made a label report with the wizzard. All
fieldnames in the report are like this: =Trim([Field1 to 6])
I have 6 fields in the report, one on each line and field 2 and 4 are empty
for most records.

Without the picture the empty lines are removed, when I insert the picture,
field (line) 2 and 4 are shown on each label even when they are empty.

I have not added any expressions manualy. The property sheet say "Yes" on
the "Can shrink" property for all fields. When I set this property to "No"
for all fields the report looks just like it does with the picture inserted.

I do not change the properties for the picture, they are all defaults.

Hope this help you to understand the problem.

Thanks for your help!!!

Asbjørn Søbye

Duane Hookom said:
Can shrink will not have any effect when there are controls directly
to
the
left or right of the "can shrink" control. If we knew your control
expressions we might be able to suggest a solution.

--
Duane Hookom
MS Access MVP


No, I didn't, but after a little bit more "investigation" I've found out
what happens:
The function that removes empty lines from the report doesn't work
when
I
insert the picture (sorry, I don't know the correct name for this function
in english, but directly translated it's "Can shrink"). Does anyone know
why?

Regards
Asbjørn Søbye

"Duane Hookom" <duanehookom@NO_SPAMhotmail.com> skrev i melding
You probably increased the size of the label.

--
Duane Hookom
MS Access MVP


I've created an address label report with four lines of text on each
label.
Then I tried to put in a logo on the right side of the label
(jpg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top