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.

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

On Tue, 28 Apr 2009 08:34:49 -0500, StargateFan
<IDon'(E-Mail Removed)> wrote:

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


>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

On Tue, 28 Apr 2009 06:32:01 -0700, Fred
<(E-Mail Removed)> wrote:

>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

On Tue, 28 Apr 2009 06:57:20 -0700, Tom van Stiphout
<(E-Mail Removed)> wrote:

>On Tue, 28 Apr 2009 08:34:49 -0500, StargateFan
><IDon'(E-Mail Removed)> wrote:
>
>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
shrink. <sigh> What else can I look for, pls?

>-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