trouble with trim

[Ken Ivins]

I have a report with a customers address textboxes.

=Trim([suFrstNam] & " " & [suLstNam] & " " & [suSufix])
=Trim([giEmployer])
=Trim([suAddr1])
=Trim([suAddr2])
=Trim([suCity] & ", " & [suState] & " " & [suPostalCode])

I want the city, state, zip textbox to move up if there is no address 2. I
made sure the each box can grow and shrink. I also made sure that each box
touches the other. I have this set of fields in 2 places on the report. The
top works fine but the bottom set leaves open space if there is no data for
address2.

I even copied the top, resized it and put it in the bottom but with no luck.
Any idea what I am doing wrong?

Thanks,
Ken Ivins

 

[Fons Ponsioen]

I suspect that you did not set the shrink to true for the
report band.
Hope this helps.
Fons

 

[Ken Ivins]

Thanks for the suggestion. That was not the answer but it got me thinking. I
ran into this a long time ago. For some reason it does not like other
information on the same row. Once I moved two label boxes up it worked fine.
There must be a reason for this but I do not know what it is.

Thanks for your time.
Ken

I suspect that you did not set the shrink to true for the
report band.
Hope this helps.
Fons

-----Original Message-----
I have a report with a customers address textboxes.

=Trim([suFrstNam] & " " & [suLstNam] & " " & [suSufix])
=Trim([giEmployer])
=Trim([suAddr1])
=Trim([suAddr2])
=Trim([suCity] & ", " & [suState] & " " & [suPostalCode])

I want the city, state, zip textbox to move up if there is no address 2. I
made sure the each box can grow and shrink. I also made sure that each box
touches the other. I have this set of fields in 2 places on the report. The
top works fine but the bottom set leaves open space if there is no data for
address2.

I even copied the top, resized it and put it in the bottom but with no luck.
Any idea what I am doing wrong?

Thanks,
Ken Ivins


.

 

[Fons Ponsioen]

The shrink property applies only to the specific box
(label or text) and anthing adjacent must also be empty or
blanked.
Take care.
FOns

-----Original Message-----
Thanks for the suggestion. That was not the answer but it got me thinking. I
ran into this a long time ago. For some reason it does not like other
information on the same row. Once I moved two label boxes up it worked fine.
There must be a reason for this but I do not know what it is.

Thanks for your time.
Ken

I suspect that you did not set the shrink to true for the
report band.
Hope this helps.
Fons

-----Original Message-----
I have a report with a customers address textboxes.

=Trim([suFrstNam] & " " & [suLstNam] & " " & [suSufix])
=Trim([giEmployer])
=Trim([suAddr1])
=Trim([suAddr2])
=Trim([suCity] & ", " & [suState] & " " & [suPostalCode])

I want the city, state, zip textbox to move up if

there
is no address 2. I

made sure the each box can grow and shrink. I also made sure that each box
touches the other. I have this set of fields in 2

places
on the report. The

top works fine but the bottom set leaves open space if there is no data for
address2.

I even copied the top, resized it and put it in the bottom but with no luck.
Any idea what I am doing wrong?

Thanks,
Ken Ivins


.

.

 

[Ken Ivins]

Ahh, I'll have to remember that.
Thanks,
Ken

The shrink property applies only to the specific box
(label or text) and anthing adjacent must also be empty or
blanked.
Take care.
FOns

-----Original Message-----
Thanks for the suggestion. That was not the answer but it got me thinking. I
ran into this a long time ago. For some reason it does not like other
information on the same row. Once I moved two label boxes up it worked fine.
There must be a reason for this but I do not know what it is.

Thanks for your time.
Ken

I suspect that you did not set the shrink to true for the
report band.
Hope this helps.
Fons
-----Original Message-----
I have a report with a customers address textboxes.

=Trim([suFrstNam] & " " & [suLstNam] & " " & [suSufix])
=Trim([giEmployer])
=Trim([suAddr1])
=Trim([suAddr2])
=Trim([suCity] & ", " & [suState] & " " & [suPostalCode])

I want the city, state, zip textbox to move up if there
is no address 2. I
made sure the each box can grow and shrink. I also made
sure that each box
touches the other. I have this set of fields in 2 places
on the report. The
top works fine but the bottom set leaves open space if
there is no data for
address2.

I even copied the top, resized it and put it in the
bottom but with no luck.
Any idea what I am doing wrong?

Thanks,
Ken Ivins


.

.