Shrink text in another "column"

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

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top