trouble with trim

  • Thread starter Thread starter Ken Ivins
  • Start date Start date
K

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
 
I suspect that you did not set the shrink to true for the
report band.
Hope this helps.
Fons
 
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




Fons Ponsioen said:
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


.
Click to expand...
Click to expand...
 
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
Click to expand...
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
Click to expand...
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


.
Click to expand...
Click to expand...


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



Fons Ponsioen said:
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


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top