Address fields

Hello everyone,
I have a report with name, address1, address2, city,state and zip
fields among others. Sometimes there is data in the Address2 field and
sometimes there isn't. My Problem is I would like the city,state zip
field to move up to addres2 when addres2 is null. What is the best way
to do this?
Thanks.

wrote:
I have a report with name, address1, address2, city,state and zip
fields among others. Sometimes there is data in the Address2 field and
sometimes there isn't. My Problem is I would like the city,state zip
field to move up to addres2 when addres2 is null. What is the best way
to do this?


Try setting CanShrink for both the address2 text box and its
section.

If your report has other controls that interfere with
CanShrink, then use a single text box for the entire address
using an expression like:

=name & Chr(13) & Chr(10) & address1 & Chr(13) & Chr(10) &
(address2 + Chr(13) + Chr(10)) & city & ", " & state & " "
& zip

--
Marsh
MVP [MS Access]

On Oct 10, 10:54 am, Marshall Barton wrote:
wrote:
I have a report with name, address1, address2, city,state and zip
fields among others. Sometimes there is data in the Address2 field and
sometimes there isn't. My Problem is I would like the city,state zip
field to move up to addres2 when addres2 is null. What is the best way
to do this?

Try setting CanShrink for both the address2 text box and its
section.

If your report has other controls that interfere with
CanShrink, then use a single text box for the entire address
using an expression like:

=name & Chr(13) & Chr(10) & address1 & Chr(13) & Chr(10) &
(address2 + Chr(13) + Chr(10)) & city & ", " & state & " "
& zip

--
Marsh
MVP [MS Access]

There seems to be a problem with the CR LF. The box will only show the
name and if I remove the CHR(13) & CHR(10) the address1 is displayed.

wrote:

On Oct 10, 10:54 am, Marshall Barton wrote:
wrote:
I have a report with name, address1, address2, city,state and zip
fields among others. Sometimes there is data in the Address2 field and
sometimes there isn't. My Problem is I would like the city,state zip
field to move up to addres2 when addres2 is null. What is the best way
to do this?

Try setting CanShrink for both the address2 text box and its
section.

If your report has other controls that interfere with
CanShrink, then use a single text box for the entire address
using an expression like:

=name & Chr(13) & Chr(10) & address1 & Chr(13) & Chr(10) &
(address2 + Chr(13) + Chr(10)) & city & ", " & state & " "
& zip


There seems to be a problem with the CR LF. The box will only show the
name and if I remove the CHR(13) & CHR(10) the address1 is displayed.


Maybe the text box is not tall enough? Try setting the text
box's CanGrow ro Yes.

Or, you could make the text box tall enough for 4 lines and
use CanShrink to deal with cases where there only 3 lines.

--
Marsh
MVP [MS Access]

On Oct 11, 9:45 am, Marshall Barton wrote:
wrote:
On Oct 10, 10:54 am, Marshall Barton wrote:
wrote:
I have a report with name, address1, address2, city,state and zip
fields among others. Sometimes there is data in the Address2 field and
sometimes there isn't. My Problem is I would like the city,state zip
field to move up to addres2 when addres2 is null. What is the best way
to do this?

Try setting CanShrink for both the address2 text box and its
section.

If your report has other controls that interfere with
CanShrink, then use a single text box for the entire address
using an expression like:

=name & Chr(13) & Chr(10) & address1 & Chr(13) & Chr(10) &
(address2 + Chr(13) + Chr(10)) & city & ", " & state & " "
& zip

There seems to be a problem with the CR LF. The box will only show the
name and if I remove the CHR(13) & CHR(10) the address1 is displayed.

Maybe the text box is not tall enough? Try setting the text
box's CanGrow ro Yes.

Or, you could make the text box tall enough for 4 lines and
use CanShrink to deal with cases where there only 3 lines.

--
Marsh
MVP [MS Access]- Hide quoted text -

- Show quoted text -

Thaks. That was it. I can't believe I didn't think of that!!!