Automatic field size change? Is that possible?

[Ladys]

Hello,

When I am printing list of people in my database, I have address field which I resized to show 5 lines of address. But some records are w/o address, so when i print, there is free space. Is it possible, that the "body part" and field will scale automatically, so my list should be like this?}:|

Name

addressline1ifNotEmpty

addressline2ifNotEmpty

addressline3ifNotEmpty

addressline4ifNotEmpty

addressline5ifNotEmpty

[LaRetta]

You might consider creating a calculation (result is text) with:

Name & ¶ &

If ( not IsEmpty ( addressline1 ) ; addressline1 & ¶ ) &

If ( not IsEmpty ( addressline2 ) ; addressline2 & ¶ ) &

If ( not IsEmpty ( addressline3 ) ; addressline3 & ¶ ) &

If ( not IsEmpty ( addressline4 ) ; addressline4 & ¶ ) &

If ( not IsEmpty ( addressline5 ) ; addressline5 )

I use this one calculation throughout my file when I wish to display a full address. Then set the field to Format > Set Sliding/Printing and slide up. Also check Reduce size of enclosing Part. :wink2:

Edited October 29, 2006 by Guest

[Ladys]

Thank you so much!

That's good. Now, I would like to extend my question little bit. For each contacts, I have about 12 fields for cellphones, Office Phones, Emails etc.

When I print list, I have ther now:

tel1: 11111111

tel2; 2222222

tel3:

tel4:

mobile1:2323232323

mobile2:

mobile3:

mobile4:

mail1: @@@@@@@

mail2:

etc.

as you can see that's not very good sollution. In this case, I preffer to have something like this:

tel1: 11111111

tel2; 2222222

mobile1:2323232323

mail1: @@@@@@@

so I would like to hide all fields and field names which are empty.

What is the best way for this?

[LaRetta]

Hi Ladys,

I would use the same principle as the last, because there is no way to hide the labels. So the label will need to be part of the calculation. It would look like:

If ( not IsEmpty ( tel1 ; "tel1: " & tel1 & ¶ ) &

If ( not IsEmpty ( tel2 ; "tel2: " & tel2 & ¶ ) &

... and so forth. Same theory (making the field large enough for max lines and then sliding). But, to tell you the truth, I'm not confident that this is the best way. Neither am I confident on the prior suggestion. This is what I use but I wonder about better ways.

LaRetta