Shrink text in another "column"

  • Thread starter Thread starter learningaccess
  • Start date Start date
L

learningaccess

In my report I have lined textboxes into columns, but don't use columns in
the page setup. I've read how to shrink the textboxes but once I add a field
to the right the blank space appears.

For example
Country serviced
email
free phone
description of support
free fax
phone

So not always is there a value in freephone, but always a value in the
"description of support" to the right. So with that to the right it shows an
empty space (where freephone would be), but I still want the freephone to
shrink. Does this make sense? This is how my textboxes are set up...
="Local Freephone: "+[Local Freephone]

Any suggestions?

I have everything set to "can shrink" = yes.

Thanks!
 
Try changing to this --
IIF([Local Freephone] Is Null, Null, "Local Freephone: "+[Local Freephone])

OR put all of the items to the right in a subform.
 
Back
Top