addresses within a rectangle box

[Doug F.]

I want to print a name, address & city within a rectangle box and if address2
or address3 is blank then squeeze the line out. This works fine with no box.
But doesn't work for me within a box. Ideas?
Thanks

 

[Allen Browne]

Try using one text box with Control Source like this (as one line):
=[FirstName] & " " & [LastName] & Chr(13) & Chr(10) &
[Address1] + Chr(13) + Chr(13) &
[Address2] + Chr(13) + Chr(13) &
[City] & " " & [State] & " " & [Zip]

Make the text box 4 lines high, with CanShrink and CanGrow set to No, and
the border color of your choice. If you wish, set internal margins (Format
tab of Properties box.)

This works on a subtle distinction between the 2 concatenation operators in
Access:
A & Null => A
A + Null => Null

 

[Doug F.]

Thanks Allen. This saves us developing a new custom report 'form'.

Try using one text box with Control Source like this (as one line):
=[FirstName] & " " & [LastName] & Chr(13) & Chr(10) &
[Address1] + Chr(13) + Chr(13) &
[Address2] + Chr(13) + Chr(13) &
[City] & " " & [State] & " " & [Zip]

Make the text box 4 lines high, with CanShrink and CanGrow set to No, and
the border color of your choice. If you wish, set internal margins (Format
tab of Properties box.)

This works on a subtle distinction between the 2 concatenation operators in
Access:
A & Null => A
A + Null => Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I want to print a name, address & city within a rectangle box and if
address2
or address3 is blank then squeeze the line out. This works fine with no
box.
But doesn't work for me within a box. Ideas?
Thanks