A2003 printing out empty row when address missing in a db ... how to fix?

[Fred]

That's not what trim does, although it might help in situations where you
have blanks spaces in fields instead of nulls.

Set the "can shrink" property for the address control and the (e.g. detail)
section to "Yes". Make sure there is nothing else on the same liine.

 

[StargateFan]

I have an address book db that I created several years back. I found
it again and am going to use it once more but I'm still having trouble
with an issue I didn't manage to fix before. I have several of the
usual fields for this type of thing, but the once giving me troube is
this one:

=Trim([Address])

I remember that trim was supposed to take care of cases when there was
no information in the field, the rest of the fields would "slide" up
so that there were no gaps. All the other fields seem to work
perfectly find except for this one above. Does anyone know what I
might have done wrong so that this doesn't work whereas all the rest
seem to?

Thanks! D

 

[Tom van Stiphout]

On Tue, 28 Apr 2009 08:34:49 -0500, StargateFan

You're probably talking about an address label report. If yes, you
need to set this control's CanShrink property to True.

-Tom.
Microsoft Access MVP

 

[StargateFan]

That's not what trim does, although it might help in situations where you
have blanks spaces in fields instead of nulls.

Set the "can shrink" property for the address control and the (e.g. detail)
section to "Yes". Make sure there is nothing else on the same liine.

Ah, you're right. It's been so long since I worked on this db that
I'd forgotten <g>. Thanks for reminding me; I remembered it was meant
to shrink _something_ <lol>.

I'll take a look at the "can shrink" property. Maybe I just missed
this field.

Thanks! D

 

[StargateFan]

On Tue, 28 Apr 2009 08:34:49 -0500, StargateFan

You're probably talking about an address label report. If yes, you
need to set this control's CanShrink property to True.

Yes, it was a report. Sorry 'bout that.

And now that I've worked in the database quite a bit today again, I've
remembered that this was an ongoing problem that I never found the
solution for. I think it was ultimately why I abandoned the project
eventually at the time since I was overwhelmed with the length of time
it took to where I got with the solution only to have such an ugly
printout.

I do have that option chosen already. It doesn't work. So obviously,
something else is at play here and now I'd like to find it. I have
both can grow and can shrink. Can grow seems to work but not the can

-Tom.
Microsoft Access MVP

I have an address book db that I created several years back. I found
it again and am going to use it once more but I'm still having trouble
with an issue I didn't manage to fix before. I have several of the
usual fields for this type of thing, but the once giving me troube is
this one:

=Trim([Address])

I remember that trim was supposed to take care of cases when there was
no information in the field, the rest of the fields would "slide" up
so that there were no gaps. All the other fields seem to work
perfectly find except for this one above. Does anyone know what I
might have done wrong so that this doesn't work whereas all the rest
seem to?

Thanks! D