suppress blanks

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

any way to suppress blank lines in an address field on a
report? blank numbers? blank currencies?

thanks,
rob
 
Yes, but it depends on what exactly you want.

Are you talking about printing...

NAME
ADDRES1
ADDRESS2
CITY, ST ZIP

and not leaving a blank if address 2 is empty?

If so, you need to look at the CAN GROW and CAN SHRINK properties in your
report design. they will allow you to do this.

For CITY, STATE and ZIP, if you are trying to get those squeezed together,
don't pull the actual fields, instead, add an unbound text box with
something like...

=[CITY] & ", " & [STATE] & " " & [ZIP]


Hope that helps,

Rick B


any way to suppress blank lines in an address field on a
report? blank numbers? blank currencies?

thanks,
rob
 
Take a look at the can shrink property for the detail band
of the repoert and for the individual text boxes. Keep in
mind that when a textbox has the can shrink property set
to yes, the psace can only shrink if all textboxes in the
horizontal line are also blank.
Hope this helps.
Fons
 
Back
Top