More Address labels

  • Thread starter Thread starter Asbjørn Søbye
  • Start date Start date
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
 
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
 
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.
 
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
 
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.
Click to expand...
when
I or
gif
Click to expand...
Click to expand...
 
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
Click to expand...
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
Click to expand...
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
Click to expand...
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
Click to expand...
Click to expand...
(jpg
or
Click to expand...
Click to expand...
 
Back
Top