Report Addresses

[Guest]

I have an addr1 and addr2 field. When the addr2 field is blank, it is
leaving an unnecessary space before the city and state. Is there a way to
tell access that if the field is blank to ignor so that no extra space is
appearing?

 

[fredg]

I have an addr1 and addr2 field. When the addr2 field is blank, it is
leaving an unnecessary space before the city and state. Is there a way to
tell access that if the field is blank to ignor so that no extra space is
appearing?

One way is to set the [Addr2] control's CanShrink property to Yes.
If there is no other control on that same line, the next line will
move up.