Mailing List Report - CanShrink/Alignment Problem

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