View Single Post
  #1  
Old February 2nd, 2005, 11:41 AM
Clare
external usenet poster
 
Posts: n/a
Default Hide text box if null value

I am creating a mailing report and would like to ignore address fields if
they are blank. I have tried the 'can shrink' which does work if the text
boxes aren't touching each other, but the gap above and below the shrunken
text box are still there so the address still has a space in the middle. If
the text boxes are touching each other then the can shrink doesn't seem to
work.

I have tried concatenating the string and using & Chr(13) & Chr(10) &
between the fields, but that obviously still leaves a line space.

In the control source expression builder I've started with this but don't
know what to put next.

IIf ( IsNull ( [Address] ) , «truepart», «falsepart»)

Any help would be greatly appreciated