Merge 2 addresses on same report

  • Thread starter Thread starter Dorothy
  • Start date Start date
D

Dorothy

I have a report (a merge letter)that has the address
fields for 2 different people in the Report Header. I
have all fields set to Can Grow and Can Shrink. The
problem is that if one person's address is 5 lines long
and the other is 4 lines long, I get a blank line in the
address of the person who only has 4 lines. Any
suggestions?
 
Dorothy;

This might sound unusual but here's what worked for me in one instance.

I set the height of the blank control to 0 and the set the property Can Grow
to Yes.

Finally aligned all controls to Top so that the controls butted each other.

May not be pretty but it worked.

Andy
 
Thanks Andy. That did work, but then I went and tried a
record that had 5 address lines and the other record had 6
and it puts an extra space in the record with 6 lines.
There must be code that can be written, but code is not my
specialty, so if anyone has any coding suggestions, please
be specific. Thanks again.
 
Dorothy;

Depending on how You need the data displayed You can use this:

=[FirstName]&" "&[LastName]
=[StreetAddress]
=[City]&", "&[State]&" "&[Zip]

One code in each control.

Andy
 
Thanks for your help. I think this will be the best fix.
-----Original Message-----
Dorothy;

Depending on how You need the data displayed You can use this:

=[FirstName]&" "&[LastName]
=[StreetAddress]
=[City]&", "&[State]&" "&[Zip]

One code in each control.

Andy

Thanks Andy. That did work, but then I went and tried a
record that had 5 address lines and the other record had 6
and it puts an extra space in the record with 6 lines.
There must be code that can be written, but code is not my
specialty, so if anyone has any coding suggestions, please
be specific. Thanks again. in
one instance. controls
butted each other. in
message property
to wrote
in Header.
I in
the
Click to expand...


.
Click to expand...
 
Back
Top