More Address labels

[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

 

[Duane Hookom]

You probably increased the size of the label.

 

[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

 

[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.

 

[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

 

[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

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

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

I or
gif

 

[Asbjørn Søbye]

That made the trick!

Thanks!

Asbjørn Søbye

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

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

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

or