Mailing List Report - CanShrink/Alignment Problem

N

Nunnsby

Hi all

I have searched and looked through the various problems regarding
CanShrink, and can't seem to find a solution to my problem.

I have a mailing list that prints labels for envelopes. The labels are
designed 3 Across by 8 Down, so 24 Labels on a page. I have got the
layout and everything else sorted out, but have the following problem.

The report layout consists of the following:

[Title][Surname]
[Address1]
[Address2]
[Address3]
[Address4]

There is no space between the Title and Surname text boxes, and they
are in fact touching. Title textbox = 2.0 cm, and the Surname textbox
= 4.5 cm. The labels are 7.0 cm in width. Font is Arial, size 8. The
title can either contain an actual title, or possibly a First Name
instead. eg: Mr. R Someone, or Richard Someone.

The problem I have is that when I view/print the labels, the blank
(empty) space in the Title textbox does not "Shrink/Disappear". ie: It
prints like this: Mr R Someone, or Richard Someone!! There
is a blank space after the text in the Title textbox. It is as though
the report does not realise that it is "empty/null" text, and that it
can be removed.

Is there a way to "align" the text in the Surname field to fit in
directly after the text in Title field??

Any help on this matter would be appreciated.

TIA

Richard
 
J

judith

Try replacing the 2 text boxes with a single text box

name: anything other than Title or Surname
control source: =[title] & " " & [surname]

This sticks the two actual field values together with a
separating blank.(& is the concatenate function)

if there is a possibility of the title being blank try

control source: =Iif(len([title] >0,[title] & " " &
[surname],[surname])

This removes the possibility of the surname being
preceeded by the separator blank
 
T

Treebeard

You can also use the Trim function to get rid of the leading blank.


judith said:
Try replacing the 2 text boxes with a single text box

name: anything other than Title or Surname
control source: =[title] & " " & [surname]

This sticks the two actual field values together with a
separating blank.(& is the concatenate function)

if there is a possibility of the title being blank try

control source: =Iif(len([title] >0,[title] & " " &
[surname],[surname])

This removes the possibility of the surname being
preceeded by the separator blank

-----Original Message-----
Hi all

I have searched and looked through the various problems regarding
CanShrink, and can't seem to find a solution to my problem.

I have a mailing list that prints labels for envelopes. The labels are
designed 3 Across by 8 Down, so 24 Labels on a page. I have got the
layout and everything else sorted out, but have the following problem.

The report layout consists of the following:

[Title][Surname]
[Address1]
[Address2]
[Address3]
[Address4]

There is no space between the Title and Surname text boxes, and they
are in fact touching. Title textbox = 2.0 cm, and the Surname textbox
= 4.5 cm. The labels are 7.0 cm in width. Font is Arial, size 8. The
title can either contain an actual title, or possibly a First Name
instead. eg: Mr. R Someone, or Richard Someone.

The problem I have is that when I view/print the labels, the blank
(empty) space in the Title textbox does not "Shrink/Disappear". ie: It
prints like this: Mr R Someone, or Richard Someone!! There
is a blank space after the text in the Title textbox. It is as though
the report does not realise that it is "empty/null" text, and that it
can be removed.

Is there a way to "align" the text in the Surname field to fit in
directly after the text in Title field??

Any help on this matter would be appreciated.

TIA

Richard
.
Click to expand...
Click to expand...
 
Top